how to get multiple id values

Hi ,

I had database table like this

ID start_date end_date

1      9/26/2009        10/2/2009
2     10/16/2010       10/22/2010
3     10/23/2010       10/29/2010
4     10/30/2010       11/5/2010

here is the scenario.When user selects start_date as 9/26/2009 and end_date as 11/5/2010,then i need to get ID values (1,2,3,4).

i tried in diff ways and not able to acheive that,can some one help me in this.

Thanks

This topic has been closed for replies.

Inspiring

In addition to cfsearching's response, what do you plan to do with the list once you have it?

Inspiring

What determines why those records match? Because

- both start_end AND end_date are between the selected dates

- either start_end AND end_date is between 9/26/2009 and 11/5/2010

...

What about records like 9/24/2009 to 11/15/2010 OR 10/15/2010 to 11/20/2010

?

Sign up