Shawn,
Sounds like BETWEEN should work for you:
SELECT foo...
FROM bar...
WHERE adatefield BETWEEN #firstdateval# AND #seconddateval#
You'll want to be careful if your adatefield contains time data - not sure
how that would affect query results - though the query will run.
hth,
Kevin
At 03:08 PM 5/31/00 -0700, you wrote:
>What is the best way to go about selecting date ranges. Like selecting
>everything from today's date up to 5 or 6 days from now?
>
>Shawn Regan
--------------------------
Kevin Marshall
Web Application Developer
eCalton.com, Inc.
Vero Beach, FL
www.ecalton.com
[EMAIL PROTECTED]
561.569.4500
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
