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

[Jan_Segier2]

Hi

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?

[VictoriaPlummer · Accepted solution]

This may help get you 80% there

[Jan_Segier2]

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!