How can I make a field visible based on a set Date?

+6

Hi! Hoping you can help!

Desired Delivery Date (date field)

Escalation (checkbox)

I am looking to make the Escalation field hidden until 2 days prior to the Desired Delivery Date. Any help would be appreciated!

+16

can you not just have a rule whereby the field is hidden when current date < (desired delivery date - 2 days)

you can use the inline function to get that comparison date in a calculated value control:

dateAddDays(date, daysToAdd)

+6

I tried creating a formatting rule: dateAddDays(DesiredDeliveryDate, (-2)), and checked hidden. That didn't work.

Also tried setting a visibility expression under the settings: fn-IsDate(DesiredDeliveryDate-2). Doesn't work either.

Any suggestions?

+5

Hi Jeremi,

You can add rule and set your condition :
dateDiffDays(formDate,Current Date)>2

Current Date you can insert in Reference | Common Tab

and check hide option.

If the answer is correct, So please mark the answer as correct.
Regards,
Reva Eka Patria

Sign up