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.
Solved! Go to 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.
Thank you for your help it works 🙂
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