This might not be a solution to your problem, but I'd thought I'd point it
out anyway.
If you DateFormat to YYYYMMDD, then every consecutive day is numerically
larger than the last.
So any calculations for dates is very easy.
jon
----- Original Message -----
From: "W Luke" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, November 04, 2000 3:26 PM
Subject: Dates in the future
> Hi,
>
> I need to query a database, and say "Find all records that match
expiry_date
> of next week." What's the correct date format in CF that I should use in
my
> query? Incidentally, the date is formatted as ddmmyyyy - i.e. 04112000
for
> today.
>
> Thanks
>
> Will
>
> --------------------------------------------------------------------------
----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
