Forum Discussion
Date format
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,
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
2 Replies
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