date time format

[topazz11]

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,

[topazz11]

is there another way instead of the function?

[MasonMA]

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. 

[MasonMA · Accepted solution]

@topazz11 

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
    Result

You will have 

When you Add a Custom Column invoke this Function

It will return results as in below picture. 

[topazz11]

it is harder than I thought.

Thank you for your help.