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]

Reply via email to