Verify whether entries in column are valid date format

[RWars]

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 solution]

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

[RWars]

Thank you Joseph, this works great!