Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

how to use multiple field formula toValidate if the input value is in YYYY-MM-DD

yychim
7 - Meteor

If it is valid, pls revert back "valid",

If it is not valid, pls "invalid"

 

Not sure do i have to use the " datetime" tool for this function or not.

 

Thanks so much.

1 REPLY 1
gawa
16 - Nebula
16 - Nebula

@yychim 

Instead of datetime functions, try Regex_Match function in Formula tool like:

 

IF REGEX_Match([Field1],"^\d{4}-\d{2}-\d{2}$")

THEN "valid"

ELSE "invalid"

ENDIF

Labels
Top Solution Authors