Forum Discussion
Tamillllll
3 years agoFrequent Visitor
Converting UTC Time(24 hr) to local time using power query.
Hi,
Can I please get help with below query,
The column "Scheduled" is in UTC in 24 hr format, How can I convert this into local time(Sydney)?
(Most of the posted solutions were for AM/PM format on;y). Not sure how this can be converted.
Snip of the Column:
I would like to do this using power query, as I would be performing few steps with date after the conversion.
(With column tool, we can convert this to AM/Pm format and convert this into local format. However would not prefer that option.)
Thanks:)
- Anonymous3 years ago
Have you tried using DateTimeZone.ToLocal?
https://learn.microsoft.com/en-us/powerquery-m/datetimezone-tolocal
--Nate
1 Reply
- AnonymousNot applicable
Have you tried using DateTimeZone.ToLocal?
https://learn.microsoft.com/en-us/powerquery-m/datetimezone-tolocal
--Nate