Hi!
I am trying to select all records from a table where a specified date falls within the range of 2 date fields (startdate and enddate).
I have tried this:
SELECT * from table WHERE startdate >= 2001-06-12 or enddate <= 2001-06-12;
This just selects all the records.
I have tried a few other variations but it never seems to work .
Can someone please help?!
I am trying to select all records from a table where a specified date falls within the range of 2 date fields (startdate and enddate).
I have tried this:
SELECT * from table WHERE startdate >= 2001-06-12 or enddate <= 2001-06-12;
This just selects all the records.
I have tried a few other variations but it never seems to work .
Can someone please help?!