Hello, Basically I am developing an application on zoho creator its quite simple, its a holiday booking system and basically the user shouldn't be able to double book a cottage,I have 2 date fields in the reservation form one for date in and one for date out. I have selected no duplicate entries so they can't book for the same day, but this doesn't stop them overlapping e.g. one person stays the 22nd april - 25th and a second person stays from the 19th- april to the 23rd the system will still let this go through does anyone have any ideas how to prevent this? Thanks

Tom