+6I 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.
+23Hi,
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.