Skip to main content

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!

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)


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?


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


Reply