How to Check if String is a Valid Date WITHOUT throwing a conversion error

[msmith6986]

I am stuck on a simple date test that I just cannot figure out.

I am testing whether a string is a valid date field or not.  My method works, however when the string is not a valid date, it throws a conversion error which kills my workflow.  Anyone know how to accomplish this task WITHOUT throwing a conversion error?

IF IsNull(DateTimeParse([DateField], "%y-%m-%d")) THEN
   "Not a date"
ELSE
   "Date"
ENDIF

Thanks so much in advance.

[grossal · Accepted solution]

Hi @msmith6986,

first of all: What are your working settings? It's very uncommon that a workflows stops when you have conversion error. Maybe uncheck the "Stop Processing When Limit is Reached" in the workflow settings.

However: Here is a solution to your question: Use Regex Match.

Example output:

Settings:

Workflow is attached. Let me know what you think.

Best

Alex

[msmith6986]

Works like a charm!  Thank you!

[SeanBuckley]

this is incomplete, a invalid date like 2024-02-30 still shows as true!! 
I don't have a solution for dates except use regex to ensure numbers then test the range, not elegant!!