Unanswered: Null Date gives 12/31/1899... I just want a blank!!!
I am using ASP 3.0, ADO and Jet 4.0 to update a table that has a date/time field. There are certain fields like "CompleteDate" that will not be filled in the first time the record set is created, and not filled in for many subsequent updates of that record. When the record is finally finished the user will put in the "CompleteDate". Until then I want to not update the field. Any ideas? I am using the following code:
rsUpdate("CompleteDate") = vbNull
and getting 12/31/1899
rsUpdate("CompleteDate") = "" gives me a runtime error of type mismatch. Should I just not update the item? There may be a case where the user had filled in that date, and now wants to blank it out... help????
Your post gave me a good direction... I tried "empty" but that still gave the 1899 date. I looked in the VBScript Documentation for "empty" and it also linked me to the keyword "null". That did the trick. "vbNull" must not work any more at Windows Script 5.6. Thanks again!