Date format

[Anonymous]

Hi guys,

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:

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

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

Thanks,

[ppm1 · Accepted solution]

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

[Anonymous]

Yes , it works.

Thanks,