How to covert date into a particular timezone?

[rickylee]

Hello,

I have data coming as UTC timezone and will need to covert it. As far as I search, I can only use the following formula:
RL_LocalTime = FORMAT(salesorders[createdon]+TIME(1,0,0),"General Date")

That means I will need to re-visit the formula when I enter into Winter time. Do we have any other solutions for this?

Thanks,
Ricky

[v-lili6-msft]

Hi@ rickylee

you may try to use IF() function to add a column like below:

RL_LocalTime =IF(Mon is Summer time, FORMAT(salesorders[createdon]+TIME(1,0,0),"General Date")
,FORMAT(salesorders[createdon]+TIME(2,0,0),"General Date"))

Best Regards,

Lin