Insert rows between two date ranges

[senarath]

Hi ,

I have a requirement as below and please advise me on this.

Person Name XYZ

Hotel Check In Date     01/Aug/2013

Hotel Check Out Date  05/Aug/2013

When I search by giving date  as 03/Aug/2013 in this particular hotel, I should see person XYZ is already a inhouse guest.

Inserting rows from 01 to 04 as Check In Date would work and if this is ok, how to handle this.

So I guess something like above or what you have mentioned would work but my confusion is that how to handle between two dates and it is not a series.

thanks,

Senarath

[MarcoWedel]

You're welcome

Regards

Marco