timezone issue

Hi Harish85 ,

Thanks Uzi2019  for the quick reply and solution. I have some other ideas to add:

Add a Custom Column, if your original datetime is in local time, you need to convert it to UTC first. Use the following formula in the custom column:

DateTimeZone.SwitchZone(DateTimeZone.From([CHANGED_AT_CRM]), 0)

This converts the datetime to UTC by setting the timezone offset to 0.

To convert the UTC datetime to CST, add another custom column with the following formula:

DateTimeZone.SwitchZone([UTC], -6)

This adjusts the timezone to CST, which is UTC-6 hours.

If you want to remove the timezone information and keep only the datetime, you can use:

DateTimeZone.RemoveZone([Custom])

Best Regards,

Neeko Tang

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