cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rickylee Member
Member

How to covert date into a particular timezone?

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

1 REPLY 1
Community Support Team
Community Support Team

Re: How to covert date into a particular timezone?

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

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.