I just tested doing an update to a date field using {}, DTOC(), and {07/29/1999} and they all worked. Blank dates in SQL Server are returned as 01/01/1900 (different versions of the ODBC driver can return 12/31/1899). I usually check for the date to be 01/01/1900 or .NULL. to see if it is empty.

BTW, I if want to query for 01/01/1900 you can SELECT somedate FROM table where somedate = ?lddate where I assign lddate = {}.

Make sense?


>Not in SPT you haven't :-)
>
>Dates go out at 'YYYY-MM-DD' or '' and nothing else.
>
>>I have used {} with no problem.
>>
>>>Sure it is.....didja know you can send "" as a blank date but not " / / "....so, toss out all your DTOCs....
>>>
>>>>>10. Did I mention blank dates? Blank Dates!! (Deserves two).
>>>>
>>>> What?... you mean you don't like what is it - 12/31/1899 - that's blank isn't it?
>>>>
>>>>
>>>>Wayne