matt.au

AF Analysis daily aggregation and daylight saving time change

Discussion created by matt.au on Oct 9, 2019
Latest reply on Oct 10, 2019 by matt.au

We have several AF Analysis that calculate the daily water flow in our system. We calculate the daily amount of flow and store it in a PI tag that resembles the base tag and add ".day" to the end of the name. The values are calculated at 2:00 am everyday and specify an offset of -2h so the value is stamped for 12:00 am. We have found that on the day when the time changes (yes we live in a state with daylight saving), the value is either written to 11:00 pm the previous day or (on the fall back day, we lose an hour) or 1:00 am on the day of the clocks spring forward. When we run reports based on these days, the value is always wrong. Is there a good way to handle the time change and get the value at the right time?

 

Regards,

 

Matt

Outcomes