The syntax for previous days is to still use DateAdd but to subtract the
days.
eg #DateAdd("d", -6, today))# will subtract 6 days.
Nick Betts
Software Engineer
Poulternet, Leeds, UK.
-----Original Message-----
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: 14 November 2000 12:49
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: Re: Date Manipulation?
> Ok, I have a date. I need to add a day, or a number of days. How the =
> devil does one do this?
The following should get the date in 6 days time, from todays'.
<cfset today = #createODBCDate(Now())#>
#DateAdd("d", 6, today))#
What's the syntax for previous dates - yesterday, day before etc?
Thanks
Will
--
Coming soon: http://www.LocalBounty.com
Local Classified Advertising for the UK
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]