Does a date fall in a date range (between start and end date)

Topic Labels: Formulas
Jump to Solution
1169 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast


3 tabs:

  1. vacation: form > start and end date vacation + linked records to “employees” so they can select themselves

  2. employees

  3. projects: per record 1 day to work on a project + linked records to “employees” to select technician

Question: is there any way to signal in any way (preferably not being able to select the technician in question) that the selected/to be selected technician is on vacation on the workday in question?

1 Solution
2 Replies 2

Thank you for sharing Victoria, much appreciated. Unfortunately, I don’t know how to script, so that 20% is still a long way ahead :slightly_smiling_face: But it does get the problem right!