Finding Dates

[johnwiliams]

Hi All,

I am developing a hotel Booking system in which i have a certain fields.

1.Room No.

2.Check In date

2. Check out date

Etc.

Suppose i booked a room for any customer between 5-09-09 to 9-09-09.

Then the room is booked between 5 to 9 .

The problem is when i am searching the status of that room between 6-09-09 to 08-09-09 its shows that room is not booked.

Plz assist me how can i handle this issue.

Thanks,

John

[Søren Dyhr]

IMHO is it elegantly solved in this template:

http://www.nightwing.com.au/FileMaker/demos7/demo705.html

--sd