I tried to use multiple fields formula to validate the input value is not the future date
However, there is sth wrong in the formula. Can u please have a look or suggest another formula for me? Thanks so much.
IF ISNULL([_CurrentField_]) THEN
"valid"
ELSEIF DateTimeParse([_CurrentField_], "%Y-%m-%d") <= DateTimeToday() THEN
"invalid"
ELSE
"valid"
ENDIF
Solved! Go to Solution.
@yychim I think you are trying to write the "valid" or "Invalid" string type to a DateTime type field, which is causing the error. Can you screenshot your Multi-Field configuration here? or use the formula tool for your validation