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: ...
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
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
Yes , it works.
Thanks,