NOW and Daylight Savings Time

lcallah93
lcallah93 Member, Infor Partner Posts: 4

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

Best Answer

Answers

  • Johan Slagt
    Johan Slagt Member, Staff Posts: 2

    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.