How to give a group of dates as a condition?

Aishwarya

Hi, I am trying to build a training diary that should prompt an error message whenever public holidays are being selected. For example , there are 10 public holidays in a year. I need an error message to be prompted while choosing any of the 10 days. How do I use these dates in my formula conditions?

 

For example, the dates given below are public holidays.

 1/1/2019

 25/12/2019

 

What condition / function do I need to use to trigger a message when any of these dates are selected from the model calendar? 

 

 

   

VIGNESH.M

Hi Aishwarya

Create List called Public Holiday

Load your Public Holiday Dates into the list.

 

Create Text format line item to convert the dates into Text.

In another line item, use finditem to check whether your selected date is exist in Public holiday list.

 

In my Example, 

Line Item A is Input field

Line iTem A_Text to Convert Date to text

 

Please see the attached pic.

 

Hope this will help.

 

-Vignesh