>>>I am using the ODBC (USER DSN ) , it automatically convert the empty date into
>>>{30/12/1899}. Please anyone has the solution of this problem?
>>
>>A quick scan through past posts would seem to indicate that it would be better to change any date fields that can be empty to accept Nulls instead. Is this practical for you?
>
>
>I can use the following way to work
>==> NVL(left_date,.NULL.) AS left_date <==
>but there is very hard to work with this way.


I can use the following way to work
==> iif(empty(left_date),.NULL.,left_date) AS left_date <==
but there is very hard to work with this way.