find records which are in between 2 dates....

I have a table Hostavailable, fields are
ID, HostID, fromDate, To date

I have to pass 2 dates form front end dt1 and dt2 (program requirement)

i have to get all the hostID available in between 2 dates(dt1 and dt2.)

Quote:

Originally Posted by nileshgarg

I have a table Hostavailable, fields are
ID, HostID, fromDate, To date

I have to pass 2 dates form front end dt1 and dt2 (program requirement)

i have to get all the hostID available in between 2 dates(dt1 and dt2.)

Hi Nilesh,

Welcome to TSDN!!

Clarify one thing, is dt1 and dt2 equal to from date and to date respectively??