Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

Topic Labels: Formulas
Jump to Solution
490 2
Showing results for 
Search instead for 
Did you mean: 


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!