Use multiple fields formula to validate the input value is not the future date

[yychim]

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

[binuacs · Accepted 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