You are viewing limited content. For full access, please sign in.

Question

Dates Using Validate with Form Rules

Forms Version 11 Self-Hosted

Updated March 17

asked on March 16

I have a date field where I want the only dates to be selectable 5 days in the future. My attempts and searching through Answers have fallen short.

Any insight on how to calculate within Form Rule?

date_validation.png (14.87 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on March 17

Hi Dustin,
The date here in the field rules doesn’t support calculations, but you can handle this by adding another hidden field.

Add a new date field "End_Date" and set its calculation to "=ADD(TODAY(), 5)".
Then hide this field using a field rule.
Finally, validate your original field with value between Current_Date and End_Date.

1 0

replied on March 17

I would actually update this to use two form fields. The first being capturing the date of submission (i.e, current date/today) and the second being date + 5. This way forms later in the process don't start failing validation if approved on a later date.

1 0

replied on March 17

Thanks! That did the trick! :D

0 0

Question

Question

Dates Using Validate with Form Rules

Answer

Replies

Sign in to reply to this post.