To check if a date column is in YYYY-MM-DD format, if not to give "Fail" as the result

[sucansa]

Hi,

I am new to Alteryx and I have a use case to test if the column has records with date displayed in "YYYY-MM-DD" format. If not, I have to mark the result as fail. Any help on this is really appreciated..

[JosephSerpis · Accepted solution]

Hi @sucansa I mocked up an example using this syntax in a formula. I attached the workflow let me know what you think?

IF DateTimeFormat([Date],"%Y-%m-%d")=[Date] THEN "Yes" ELSE "Fail" ENDIF 

[TonyA]

@JosephSerpis 's solution has the added benefit of not just checking the syntax but verifying that the date is valid without doing a bunch of extra checks. So 2019-02-29 may have the right syntax but still be rejected.

[JoeS]

ignore me 🙂

[sucansa]

Thank you! This worked the magic.

[swuenschel]

Thank you for this bit of code.  I've been struggling with how to test the date time formats prior to running them through Parse and getting errors.