09-13-2012 12:16 AM
Same machine, 1 database.
Database is changed from Act2011 Pro to Act2012 Premium
All dates are shifted with 1 day earlier.
We are in timezone Belgium (GMT+2) in summer, GMT+1 in winter.
This is the second database in this week i encounter the same problem (the first is from Act2005 to Act2012)
Is there a short remedy for this inconvenience ?
09-13-2012 04:56 PM
Has anyone had the same problem?
People are npw borned the day before !!!!
Customer is not amused.
09-13-2012 08:15 PM
That problem is typically caused by the computers reagional settings. Every date in MSSQL has a time component and if it isn't used or specified it defaults to 12:00 AM (Midnight). Changing the computer regional settings can cause the date to shift because ACT! records the time as zulu with an offset.
09-15-2012 01:46 PM
Problem is that this conversion happened on the same machine, so the time zone (and this user has only 1 (little country you know), so this should not happen !!
The only thing where i can think on,- and in this case we have to talk about a bug - is winter and summer time, which is there for 6 months.