NOW and Daylight Savings Time

Lisa Callahan

Is there a flag field or some other way to identify if the customer is in standard or daylight savings time? I have created a BQL expression for Pacific time using DateAdd which will work until 11/03/2024, when DST ends.

DateAdd(Hour,-7,NOW)

Ideally I would like to avoid having to edit the expression whenever the time changes.

Please and thank you,

Lisa

Diane McElhiney

Here's an option I've implemented in a customer's space.

Johan Slagt

Infor ERPs send their datetime columns in UTC format to data lake. This means that when you are extracting data from data lake the datetime columns are in UTC. However, it is possible to convert the datetimes upon extraction to other time zones using the "Using Time Zone Shifting" functionality in Birst (check Birst Help).

However, this does not mean that when you are using Infor Birst Analytics that you should start changing space processing time zones!! At this point in time, LN Analytics is the only analytic supporting this functionality from version 2023.10 onwards (see their admin guide for their restrictions). Making inappropriate changes could result in incorrect data as functions like NOW are based on the space processing time zone.

Diane McElhiney

@lcallah93

I'm attaching this document which determines day light saving vs. standard then the variables can be used within a Scripted Source or another expression. I have used this method on the Birst LoadCompletionTime in a customer's dashboard to represent the time in their Eastern timezone.