avoid default day 1/1/1900 1

[fanghua]

every time i insert a record, if i don't specify date or '', it will always have 1/1/1900 in the db. this has cause a lot of error and confusion. what's the suggestion to avoid this.... thanks!

 

[SQLBill]

What do you want it to be?

I do not believe you can make DATETIME/SMALLDATETIME NULLable. So you have to enter something.

You could ALTER the column to have a default of whatever you might want.

-SQLBill

 

[ArtieChoke]

You can make a datetime field nullable.

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[amorous]

Whenever you are inserting the record you should check the condition on the date variable and Insert NULL.

For example

If request("datevar")<>"" Then

SQL= "INSERT INTO TABLENAME(datevar) VALUES('"&request("datevar")&"')"

Else

SQL= "INSERT INTO TABLENAME(datevar) VALUES(NULL)"

End IF


Hope that helps

Thanks

VJ