AnsweredAssumed Answered

calculation or script to determine if already booked

Question asked by DavidGunter on Feb 16, 2016
Latest reply on Feb 16, 2016 by DavidGunter

My house rental reservation program needs a calculation or script to determine whether a query for a date range at a rental property is already booked. The reservation table, indicates renter ID, arrival and depart dates as seperate fields, and at which property from a value list.

 

The missing step is to block a new reservation that conflicts with an existing one. I'm thinking a script, a conditional or a validated calculation would do the trick but do not know how to construct it. A dialog indicating ' dates are not available' would be ideal. Any ideas?

Outcomes