Alejandro

You should also be aware that if you have any blank date fields that they will be changed to 12/30/1899 or possibly 1/1/1900 in SQL Server, since ODBC has no concept of blank dates.

As far as changing code globally, you can use GOFISH app from downloads to search for occurrences of specific text and change it using its edit capabilities. Much faster and less error prone than manually searching and editing multiple files.

Or, as Sergey suggested, you can map your datetime fields to date data type in your remote views and your code needs no changes except to handle the blank dates being replaced with a default date.

HTH
Elmer