1/1/1900 problem

[lucyc]

How do you set null on a datetime data type field in SQL. If I have a date, it is ok, but if I leave it blank, it becomes 1/1/1900. Thanks in advance.

 

[Chopstik]

You should be able to set it to null. For example, I have a function in my component that checks whether the field being updated has a value or not. If it does, then I set the update field to that value, else I set it to "null". HTH

Everything is absolute. Everything else is relative.

 

[mww22]

if date = "" then
date = ''
end if