select * from table_name where (start_date >='2002-10-01' and start_date
<='2002-12-10') or (end_date >='2002-10-01' and end_date <='2002-12-10')
At 01:08 11.12.2002, [-^-!-%- said:
[snip]
>
>Hello everyone,
>
>I need to get a recordset between two dates, a
Hello everyone,
I need to get a recordset between two dates, and am having a little
trouble. I was wondering if someone could me make it more efficient.
The goal:
Each record has a start_date and end_date field. I want to be able to
extract records that has the start_date and/or end_date, withi
2 matches
Mail list logo