convert Date

[Anonymous]

Hi,

Please sugget how can i convert the belwo format to normal dateTime Format:

existing: 

01 Nov 2019 20:20:37:00

requiremnt:

11/01/2019 8:20:37 PM  or even if manage to get the date like... 11/01/2019.

Regards,

Chandra

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may add a custom column in Query Editor.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjBU8MsvUzAyMLQEElZAZGxuZWCgFBsLAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each Text.ReplaceRange([Column1], 20, 1, ".")),
    #"Changed Type" = Table.TransformColumnTypes(#"Added Custom",{{"Custom", type datetime}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"Custom", type date}})
in
    #"Changed Type1"

[asc]

select column and then apply formatting