How can I present reservation custom properties Start and End in server’s time?

Solved625 views
0
0 Comments

I need to present the reservation custom properties Start and End in Visual Overview, but because they are shown as internally defined (in UTC time), a conversion to the server’s time is required.

By using the placeholder Subtract, I was able to offset by the required number of hours but this approach got broken when the daylight saving time ended (and will fail again with the start of the daylight saving).

Is there any other way to present these times in the server’s time?

Gelber Mahecha [SLC] [DevOps Enabler] Selected answer as best 25th November 2021

1 Answer

3
12.78K 1 Comment

Hi Gelber,

You can calculate the time zone difference by subtracting the DataMinerTime and the UTCTime.

Config:

Result:

You can now add this difference to your UTC times in the booking.

Text for easy copy-pasting:

[Subtract:[DataMinerTime],[UTCTime]]

Gelber Mahecha [SLC] [DevOps Enabler] Selected answer as best 25th November 2021
Gelber Mahecha [SLC] [DevOps Enabler] commented

Thanks Sebastiaan. I’ve modified the shapes using the fixed time difference and it seems to work in DMA version 10.1.12.