OldSkoolSkater
MIS
Hi All,
We are having a problem with a crystal report that is looking at Baan ERP data, stored on an AS400 server.
If I look at the data in Baan a date/time field would display as 23/11/01 00:00:00, but on crystal this displays as 22/11/01 23:00:00.
The AS400 stores everything at Greenwich Mean Time and then displays date/times based on a Universal Offset value ie: +1 or 0.
To display the correct date/time on the crystal report, I would like to calculate all date/times based on the Universal Offset value in AS400 (+1 or 0).
We have checked all of our servers and PCs to make sure the times are correct. Has anyone got any ideas on how I can extract this Offset Value from the AS400? or have I missed some settings in Crystal that would put this right.
We are having a problem with a crystal report that is looking at Baan ERP data, stored on an AS400 server.
If I look at the data in Baan a date/time field would display as 23/11/01 00:00:00, but on crystal this displays as 22/11/01 23:00:00.
The AS400 stores everything at Greenwich Mean Time and then displays date/times based on a Universal Offset value ie: +1 or 0.
To display the correct date/time on the crystal report, I would like to calculate all date/times based on the Universal Offset value in AS400 (+1 or 0).
We have checked all of our servers and PCs to make sure the times are correct. Has anyone got any ideas on how I can extract this Offset Value from the AS400? or have I missed some settings in Crystal that would put this right.