Report to convert illegal date-values v2

This report 79001 is able to locate any illegal date-values in the database and convert this dates to the date 1. January 1764.

When converting a customer database from Native database to SQL, it is a well known issue that the Native database is able to handle data-fields from year 0000 (despite that this year is non existing) and SQL only is able to handle date-values from the year 1763.
Many native databases have date values in date-fields before the year 1763 often because the user had typed data wrong.
The problem occurs when restoring the company backup into SQL-database. It can be very difficult to locate all the date-values in the database and convert them to a value that is valid and handlebar for SQL. It is our experience that there often is several error related to this issue.

This report 79001 is able to locate any illegal date-values in the database and convert this dates to the date 1. January 1764.

Any values converted this way is stored in change-log.

Version 2 also handle DateTime fields.