Forum Discussion
date time format
Could anyone help to convert this date format in Power Query?
2025-01-22T09:42:02.541-06:00[America/Chicago]
-> 1/22/2025 9:42:02 AM
Thanks,
Here's the function you can re-use in Power Query.
Create a blank query and paste below M in it.
(DateText as text) as datetime => let CleanText = Text.BeforeDelimiter(DateText, "["), Parsed = DateTimeZone.FromText(CleanText), Result = DateTimeZone.RemoveZone(Parsed) in ResultYou will have
When you Add a Custom Column invoke this Function
It will return results as in below picture.
4 Replies
Here's the function you can re-use in Power Query.
Create a blank query and paste below M in it.
(DateText as text) as datetime => let CleanText = Text.BeforeDelimiter(DateText, "["), Parsed = DateTimeZone.FromText(CleanText), Result = DateTimeZone.RemoveZone(Parsed) in ResultYou will have
When you Add a Custom Column invoke this Function
It will return results as in below picture.
it is harder than I thought.
Thank you for your help.
is there another way instead of the function?
Hi
Yes! Function is better when you need to reuse it later in your data transformation. If you prefer a regular way for a one-time use,
When you add a Custom Column, paste the M code
let
CleanText = Text.BeforeDelimiter([OriginalDate], "["),
Parsed = DateTimeZone.FromText(CleanText),
Result = DateTimeZone.RemoveZone(Parsed)
in
Resultand replace the [OriginalDate] with your actual Date Column.
