cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

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

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!

Labels: (1)
0 Kudos
Reply
3 Replies
Workflow Hero

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

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)

Accept as Solution Reply
Workflow Hero

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

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?

0 Kudos
Accept as Solution Reply
Workflow Hero

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

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

0 Kudos
Accept as Solution Reply