Ahh, in that case:
WHERE ( Coupons.ExpiryDate BETWEEN
#CreateODBCDateTime(Int(Now()))# AND
#CreateODBCDateTime(Int(Now()+1))# ) AND
...
Jim
-----Original Message-----
From: Jennifer L <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Saturday, May 27, 2000 9:17 PM
Subject: Re: Listing Items That Expire Today? Help!
What he is trying to do threw me at first too, but what he wants is the
records that expired in the last 24 hours. If he checked for records that
expired on today's date and before the time that the query is run, to get
records that expire today at 11:59PM the query would have to be run at
11:59PM. If he just wanted records that expire today at any time, this
method would work.
------------------------------------------------------------------------------
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.
