How to give a group of dates as a condition?

Highlighted
Contributor

How to give a group of dates as a condition?

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? 

 

 

   

4 REPLIES 4
Frequent Contributor

Re: How to give a group of dates as a condition?

Hi Aishwarya

Photo1.png

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

 

Contributor

Re: How to give a group of dates as a condition?

Hi Vignesh,

 

       Thanks a lot for your immediate response. Yes, your solution is helpful. 

 

Thanks and regards,

Aishwarya

Expert

Re: How to give a group of dates as a condition?

It can be even simpler

Create a module by day and have a line item indicating holidays (test, or boolean)

Create a line item referencing the above using a LOOKUP on the input date

 

Holiday Calendar.Public Holiday[lookup:Selected Date]

 

That will return the public holiday flag

 

You could publish on the dashboard separately or hav is within the input grid

 

David

Contributor

Re: How to give a group of dates as a condition?

Hi David,

 

  Thank you so much for your solution.

 

Thanks and regards,

Aishwarya