fmSQL Synch (v2.0)

Correct Date & Time (This page has not been updated for v2 yet. See the README file for current details.)

It is important that both the computers that FileMaker and the SQL server run on have the same time. Any differences in time could throw out the conflict checking routines. The date/time each record was last modified is used to determine whether the records should be compared with each other on a field-by-field basis for merge conflicts.

Date/time comparisons are done using the time for the local time zone for each server. So if the two servers are in different time zones, then you will need to do some date calculations in the SQL statements to convert values to the time zone of the FileMaker server.

As long as both servers use a time server to set their time on a regular basis (& use the same time zone), then time differences should not be an issue.