For the Date field in Baan(we use Oracle database), if it is empty, Baan store it as 01-01-9999, which is not suport by microsoft SQL sever.
i need to download the baan data into SQL server, but date field is always problem, Baan said i should write a view for that, but i don't think it is practical since i am not sure when and what table i need to download and besides, Baan has so many tables, every table has the same problem if date field is empty.

Any body has bright idea on how to write a VB script, for instance to check the date field during loading, let's say i am using DTS tranform function of Microsoft SQL Server.

You can first download the whole base, change the oradata parameter in db_resource like this oradate:1 and reload the base.
After that the date will be stored as 1 JAN 4712BC.

There is a case opened in the baan KB.

Regards

Sorry.