09-13-2012 08:03 AM
For some strange reason, all my customer birthdates backed up by one day. (i.e. If the actual date entered was September 13, 2012, my ACT!2010 now reflects the date of September 12, 2012.) What is the cause of this error and how do I go about returning all my dates to their original, correct dates? Thanks. - Gary
09-14-2012 04:27 PM
This can happen in ACT! after a conversion of the database through a number of ACT! versions and can be corrected but requires a utility to be run across the erroneous date fields to adjust thenm in mass by one day. We could do it for you, there would be a cost but not a great deal.
09-17-2012 08:50 AM
Thanks for the tip, Greg. Unfortunately that was not the issue. Besides, I don't think that would make my entire database back up by one day for all birthdates, eh? Thanks for trying. - Gary
09-17-2012 08:58 AM
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
09-17-2012 09:11 AM
Actully it can. All dates in MSSQL have a time component and when the time isn't specified or the default time is used, the time used is 12:00 AM (midnight) so a one time zone change could make all the bithdays change by one day. Daylight savings time shouldn't make a differance because the times are stored as Zulu time with a time zone offset.