Getting Problem in DATE/TIME Data type in MS Acces
I am getting problem in DATE/TIME data type in MS Access data base using ASP forms, Following is the senario.
There are three DATE/TIME field in MS Access, Date1, Date2, Date3 and I have three text boxes in ASP, from where i am entering dates. If i enter only one date in one text box and rest of them are null and when i click on submit button then the insert into qurey will fire and then it give me an error "Data Type mismatch", insted of if i enter the three dates in text box it's accept the data and post into to database.
Rather then i write a check in ASP that if the text box is "" means Empty then it insert word "NULL" not "" in date/time field in database but again it's give me an error Data type mismatch because it's not acsept word NULL in date/time data type.
What would i do if don't want to enter date in rest of 2 Date/Time field??? because it's dosen't accepting word NULL or empty value in database.