05-19-2009 10:35 AM
I'm getting an SQL DateTime overflow error Date must be between 1/1/1753 12:00:00 AM and 12/31/9999 12:00:00 PM. Contact Administrator
when attempting to sync Act 9.0.
How do I correct this error? I have been through all the date fields on both the main and remote database.
05-22-2009 06:55 AM
Usually this error is caused by invalid dates or times. When you looked at the date fields, did you also look at the activities? If you haven't, go to the Task List and add these columns: Date, End Date, Time, Duration. Make sure show cleared activities is enabled and look after the columns to see if there are any negative values, invalid dates and durations. Delete any that you find from the parent and remote database and try to sync again.
If the issue is remote specific, you can try creating a new remote database.