Solved: Date format

Anonymous · ‎10-19-2023

I´m working with report and I have a problem with the data in a column that refers to a date.

Here is a sample of the data:

Sample Data.PNG

When trying to convert to a date, this the error:

I have tried different changes in the format with no results.

Thanks,

ppm1 · ‎10-19-2023

Are you in a locale that uses yyyyddMM format? You can convert it to Text type and use Date.FromText with the Format option like this.

Date.FromText([Date], [Format = "yyyyddMM"])

Pat

Microsoft Employee

ppm1 · ‎10-19-2023

Are you in a locale that uses yyyyddMM format? You can convert it to Text type and use Date.FromText with the Format option like this.

Date.FromText([Date], [Format = "yyyyddMM"])

Pat

Microsoft Employee

Anonymous · ‎10-19-2023

Yes , it works.

Thanks,

Date format