Datasphere - Convert UTC to EST considering DST(Daylight Savings) changes

[prasanna_korada2]

We would like to convert dates from UTC to EST in Datasphere modeling and found UTCTOLOCAL() function but it is not covering DST(Daylight Savings). Any suggestions on this?

[Simon_Ye]

Hi,

You can use the UTCTOLOCAL() function, it has already considered the daylight savings as below:

In sample 1(May 1st,2023), UTC is 4 hours ahead EST; In sample 2(Feb 1,2023), it's 5 hours ahead EST.