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.
Solved! Go to 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
Works like a charm! Thank you!