Are you using SQL Server? If so, SQL Server does not have the concept of "empty dates." In SQL Server, date fields are either NULL or a date (but not empty date.) If you don't specify a date, SQL Server will store 1/1/1900 on all date fields.

I am surprised you are getting the day before 1/1/1900, Are you substracting a day from your fields? What DBMS are you using? Perhaps Oracle or DB2 use another value for dates.


>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