Navisionerz, I got a dilemma
I have a bespoke table in NAV which includes a datetime field, when a record is updated/created the datetime field is populated with the current time. In this scenario if the record is created/updated the field is updated. When I compare the same record in both NAV and SQL, the SQL table holds the correct time stamp of i.e. 1230hrs but in NAV the field in the same table/record shows a time of one hour ahead 1330hrs.
When comparing records before and after the beginning of Daylight Savings Time 30/03/2014, the records prior to this date match, but after this date, there is inconsistency.
Note that entries created/updated here are done outside of NAV.
I create a sales order, on the header table there is bespoke datetime field which logs the creation date and time. I then compare the times logged and it correctly displayed the time as 1230hrs, but in SQL the same record logged a time of 1130hrs
Note that scenrio 2 was done in NAV.
So I am confused. can anyone help?