Can someone please remind me what is the value that Informix store in the tables for null dates.

Regards,
kereni

Note that Baan doesn't use the native "date" format for date fields: it simpy uses an integer type (same as for storing "longs").

This leaves me a question: is your original question still valid?

Regards,
Jaap

Thanks for the information. But, is the database filed will be stay empty, zero or other date format like 01/01/0001?

Regards,
kereni