Check for Duplicate Date Range
I am trying to update my reservation application to check for units already booked. For a specific property, the unit is booked from a start date to an end date. What I am trying to do is to add code to check if some one tries to add another record where the from and to dates overlap.
For example, Unit #1 (Unit) is reserved from (Check_In field) July 18, 2013 to July 25, 2013 (Check_Out field). If a user tries to book this same unit from July 20 to July 30, I want them to get an error message.
Is this possible?
For example, Unit #1 (Unit) is reserved from (Check_In field) July 18, 2013 to July 25, 2013 (Check_Out field). If a user tries to book this same unit from July 20 to July 30, I want them to get an error message.
Is this possible?