Verify whether entries in column are valid date format

Question

I'm developing data quality rules to screen datasets and I want to check a column (date of birth) to ensure that the entries are in any proper date format. I want to use the filter tool, to ouput in the 'True' output the rows that do not conform to any valid date format. I was thinking of using this formula:

IF DateTimeFormat([DOB], f) THEN 1 ELSE 0 , but since I want any valid date format to be allowable, would there be any easier way to do this rather than typing out an expression for every possible date format?

Thank you

JosephSerpis · Accepted Answer

Hi @RWars you might this workflow useful I made it for another post. Link in case you want to understand the logic more.