> I suspect your error is possibly cuased by the old database being in
> dialect 1 and the new one being in dialect 3. What is the output of the
> following command for both databases please:
>
> gstat -header <database_name>
>
> Look for "ODS version" and "Database dialect".
>

The original DB is dialect 1. If I am using gbak to restore the DB the the new DB must also be dialect 1. But just on the off chance, I checked the new database. It is dialect 1.

As long as both DBs are dialect 1 a DATE is a TIMESTAMP and I should have no problem. Correct??