date time format

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.