Re: Retrieve listings between two dates?
| From: | Dan Malcolm | Date: | Tue, 09 Jan 2001 23:28:08 +0000 |
| Subject: | Re: Retrieve listings between two dates? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5767@lists.php.net to get a copy of this message | ||
Tried:
SELECT * FROM calendar WHERE Year < #2000-12-31# AND Year > #2000-01-01#
ORDER BY Start ASC
supplied by "mqqla". I used his format against an Access 2000 database and
it worked perfectly.
dm
""Keith Spiller"" <larentium@gilanet.com> wrote in message
news:03f301c03e46$2515c370$6bdaead8@enigma...
Using the select command, how would you retrieve listings only between
certain dates?
"SELECT * FROM calendar WHERE Year < '2000-12-31' AND > '2002-01-01'
ORDER
BY Start ASC" ??? (This does not work)...
Is this even possible?
Keith