Hi!

The ODBC do not know what is empty date - it does not support such value. When data go through ODBC, all empty dates are replaced by the minimum allowed date. In such case use NULL when you need empty date.

>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