Label Control Visiblity Rule - Based on Calendar Value

  • 21 August 2019
  • 2 replies
  • 0 views

Badge +6

I have a label control that I want to display if a calendar control contains a date within the next 14 days. By default I want to have the label control hidden, and show when the date falls within the window. So far I have not been able to find the right combination to acheive this funcationality.

 

4033iFBD4F5A23401C40E.jpg4034i76C940CF1F25FFDA.jpg


2 replies

Userlevel 6
Badge +22

Hi,

 

The following formula will do the trick if you use a hide rule on your label.

not(and(greaterThanOrEqual(StartTime,{Common:CurrentDate}),lessThanOrEqual(StartTime,dateAddDays({Common:CurrentDate},14))))

Please see the attached form example if you require.

Badge +6

works perfectly!

Reply