Forum Discussion
Solved
Need help converting Date/Time timestamp to different timezone
Hello all, I have a "TimeStamp" column of datatype Time/Date that I want to offset by 2 hours from UTC to my local time zone. It needs to be Time/Date because I use it for incremental refresh, wh...
Not familiar with that function but it does to be different than I expected. Simple fix is just to add 2 hours to your datetime columns as follows
=[DateTimeColumn] + #duration(0,2,0,0)
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Not familiar with that function but it does to be different than I expected. Simple fix is just to add 2 hours to your datetime columns as follows
=[DateTimeColumn] + #duration(0,2,0,0)
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
This worked, thank you.
