Is a date in a string column.

[mtatum]

I have a string column that should only have yyyy-dd-mm date formats in it, but at times it will have something like TBD.  I want to clear out anything in that column that isn't yyyy-mm-dd.  

Thank you

[JosephSerpis · Accepted solution]

Hi @mtatum I mocked up a workflow that checks for both yyyy-dd-mm and yyyy-mm-dd and replaces anything that doesn't match that criteria. Let me know what you think?

[patrick_digan]

@mtatum If it's a valid date format, you can use a select tool and change the type to date.

[mtatum]

Thank you Joseph!  Worked like a charm.