The DateAdd function et al are designed to do date manipulation, painlessly.
HTH
dick
At 6:16 PM -0500 11/4/00, Norman Elton wrote:
>You need to remember that 20001031 (Oct. 31st) + 1 = 20001101 (Nov. 1). The
>"adding one" trick works until you reach the end of the month.
>
>Norman Elton
>Information Technology
>College of William & Mary
>
>
>-----Original Message-----
>From: W Luke [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, November 04, 2000 5:32 PM
>To: CF-Talk
>Subject: Re: Dates in the future
>
>
>> 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.
>
>Seems logical...is it really just a case of calculation, though? For
>instance - taking today to be 20001104 - next week would be 20001104 + 7?
>
>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]
------------------------------------------------------------------------------------------------
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]
