SELECT, where value is Between

[Anon]

I have a select statement and I want to select a record where date is between a specified startDate and endDate.

Do I have to say:
WHERE DateDelivered > $startDate AND DateDelivered < $endDate

that doesn't seem to work for me.

[Anon]

The DateDelivered column in your table would have to be either in YYYYMMDD or similar format or a UNIX timestamp for that to work. And you might have to put quotes around the values like this.

WHERE DateDelivered > '$startDate' AND DateDelivered < '$endDate'