>Are you using SQL Server?
No this is a fox back end through Microsoft ODBC Driver Ver. 6.01.8629.01
i am thinking this has to do with some ODBC concept of .null. for date fields. I am going to double check all the field settings even though I didn't conciously change them
>
>I am surprised you are getting the day before 1/1/1900, Are you substracting a day from your fields? No, These are dates that are filled in as certain events occur.
>
>>I have a remote view on a single table with several date fields. The view was created in the view designer.
>>When I browse this view from the project manager the empty date fields show up with 12/31/1899 in them.
>>
>>set century is on
>>set strictdate is 1
>>
>>if the view is set up as a local view, it displays normally.
>>
>>I have obviously done something silly, but I am at a loss as to where to begin.
>>
>>Thank you in advance.
>>
>>Brenda Erikson
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only