Ive run into this problem as well (MSSQL7). I found that my INSERTS were
placing a blank into the date field and it would result in this type of a
date as a default. I changed my code check for the empty date fields and
NOT insert anything if blank. I then did an UPDATE for all the bogus dates
and SET them to NULL. Works fine now.
Hope it helps....
-Adrian
>Hi All,
>
>I'm "Selecting * From..." using a Visual FoxPro free table. Some of the
>date fields (VFP date format) are blank. When displayed with CFTable or
>CFGridCol they appear "1899-12-30". I must resolve this. Any =
>suggestions? TIA.
>Regards,
>Paige
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
