Convert date from number string to date format and check if the date is valid

[Vaib]

Hi

I want to convert number 20210325 (yyyymmdd) to date format and check if it's a valid date using formula tool. How can I do this.

[Emil_Kos · Accepted solution]

Hi @Vaib,

You need to use below formula:

DateTimeParse(ToString([Field1]),'%y%m%d')

The output:

Regarding the validation, the column will become null if field will not have a proper date in the format specified in the formula tool.

[Vaib]

Thank you for your help it works 🙂

[MikeLR]

Great answer @Emil_Kos. I have this bookmarked as I still can't remember all the different specifiers! 

https://help.alteryx.com/current/designer/datetime-functions