I need to display on a custom GI the start and end log TIME
(from the Appointment screen FS300200).
As date-time fields are stored in UTC format.
Therefore I use the next well known approach to calculate hour’s part into local time zone:
Hour (
DateAdd (
[FSLog.DateTimeBegin],
'h',
DateDiff (
'h',
NowUTC(),
Now()
)
)
)
But, the problem.
How to manage winter/summer saving time periods?
The customer is from Singapore, and Singapore doesn't have saving time period.
With this Now/NowUTC approach for records from winter period a time is provided with one extra hour.
Best answer by olexandrProkopovych94
View original