Text to Date

[MalvikaBhasin]

Hi,

Why am I unable to change TEXT to DATE for a column.

Regards

Malvika

[Anonymous]

Hi All,

Fisrtly, thanks to all for your kind replies!
And @MalvikaBhasin ,

Has your problem been solved after all this time, or has a new problem arisen, if there are any other questions on this issue, feel free to contact me and I'll get back to you as soon as I receive the message.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Ahmedx]

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

[Thennarasu_R]

Hi @MalvikaBhasin 

Go to tranform data and change the column data type 

Thanks,
Thennarasu R

[MalvikaBhasin]

Thanks. But why is it working partially for me? Can you help identify issue from below image?

Regards

Malvika

[Joe_Barry]

Hi @MalvikaBhasin 

Go to Transform data to the table, highlight the column and convert to Date

Joe

[MalvikaBhasin]

Thanks. But why is it working partially for me? Can you help identify issue from below image?

Regards

Malvika

[SachinNandanwar]

Your data contains dates in the format dd/mm/yyyy.

For instance the input date 13/01/2024 is formatted as day/month/year. But the report expects dates in the format mm/dd/yyyy where the month value should not exceed 12. So when the report encounters a date with a month value greater than 12 it would create an error.

[Ashish_Mathur]

Hi, Perhaps the cells where you see errors, the date format there is m/d/y. Since your system is formatted to only understand d/m/y dates, those cells are returning errors.

[mostho]

How does the column look like before the transformation? i guess the "dates" are in a format which the function cannot handle by default. maybe you have to adjust the function call with an optional culture parameter or a format specification.