>Hi,
>
>I am using the ODBC (USER DSN ) , it automatically convert the empty date into {30/12/1899}. Please you have the solution of this problem?
>
>thanks,
>
>Mobeen.
Mobeen,
For ODBC there is no empty date. Dates are calculated as numbers where integer part holds the days as offsett from {30/12/1899} and decimal part keeps the time as fractions of the day. An empty value defaults to 0 and it corresponds to base date {30/12/1899}.
You can't have an empty date but a null. In your backend set date field to accept null.
Cetin