Forum Discussion

MalvikaBhasin's avatar
MalvikaBhasin
Helper III
2 years ago

Text to Date

Hi,   Why am I unable to change TEXT to DATE for a column.     Regards Malvika  
Need Help
Ahmedx's avatar
Ahmedx
Super User
2 years ago

pls try this code in power query

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjTQNTDWNTIwtFCK1QFyDVG5RqhcYwQ3FgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t]),
    Custom1 = Table.TransformColumns( Source, {"Date",(x)=> Date.FromText(x,[Format="dd-MM-yyyy"])})
in
    Custom1