Date string

[alexb]

Hi,

I'm importing a csv file with dates in this format: "Jan 1, 2017 6:01:12 AM PST". How do i transform these text strings to actual dates in PowerBI when importing?

Thanks.

[MarcelBeug]

let
    Source = "Jan 1, 2017 6:01:12 AM PST",
    #"Converted to Table" = #table(1, {{Source}}),
    #"Extracted Text Before Delimiter" = Table.TransformColumns(#"Converted to Table", {{"Column1", each Text.BeforeDelimiter(_, " PST", 0), type text}}),
    #"Parsed Date" = Table.TransformColumns(#"Extracted Text Before Delimiter",{{"Column1", each Date.From(DateTimeZone.From(_)), type date}})
in
    #"Parsed Date"

[MarcelBeug]

https://www.mrexcel.com/forum/power-bi/1036366-date-string.html