Forum Discussion
Solved
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.
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
Result
and replace the [OriginalDate] with your actual Date Column.