PDA

View Full Version : Compensating UTC time, to show real time



begunrom
04-10-2008, 04:18 AM
Our ERP package stores the date/time as UTC, so the value stored is independant of the timezone.

This means that in my case, in the summer time shown in the reports should be UTC+2 and in the winter UTC+1

As a work around i would like to use a formulla to add 2 hours to the value specified in the field.

I am struggling with the syntax. What would be the correct version.