RE: Date Manipulation?

2000-11-14 Thread Nick Betts
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'. #DateAdd("d", 6, today))# What's the sy

Re: Date Manipulation?

2000-11-14 Thread Rob Keniger
on 11/14/00 10:48 PM, W Luke at [EMAIL PROTECTED] wrote: > > The following should get the date in 6 days time, from todays'. > > > #DateAdd("d", 6, today))# > > What's the syntax for previous dates - yesterday, day before etc? #DateAdd("d", -6, today))# Just make the dateadd parameter neg

Re: Date Manipulation?

2000-11-14 Thread W Luke
> 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'. #DateAdd("d", 6, today))# What's the syntax for previous dates - yesterday, day before etc? Thanks Will -- Coming soon: http

Re: Date Manipulation?

2000-11-13 Thread Justin Scott
Use the DateAdd function... DateAdd(datepart, number, date) so it would be... ___ Justin Scott :: [DtDNS Administrator] http://www.dtdns.com - Original Message - From: "Willy Ray" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent:

RE: Date Manipulation?

2000-11-13 Thread JustinMacCarthy
DateAdd('d',number,date) Justin MacCarthy > -Original Message- > From: Willy Ray [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 13, 2000 4:34 PM > To: CF-Talk > Subject: Date Manipulation? > > > > Ok, I have a date. I need to add a day, or a number of days. > How the devil doe

RE: Date Manipulation?

2000-11-13 Thread Rich Wild
> Ok, I have a date. I need to add a day, or a number of days. > How the devil does one do this? dateadd('d', numberofdaysvar, datevar) --- Rich Wild Senior Web Designer --- e-mango.com lt

RE: Date Manipulation?

2000-11-13 Thread Doug Powell
If your grabbing the date from a DB you can use // Set Date to Whatever DateWanted = queryname.date; DateWanted = DateAdd("d", 5, DateWanted); Or you can use Or however you want -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: Monday, No

RE: Date Manipulation?

2000-11-13 Thread Andy Ewings
Use the DateAdd function like so... #DateAdd(d,2,mydate)# This adds 2 days to the variable mydate. If you are using ColdFusion studio have a look at the help file for the full syntax -- Andrew Ewings Project Manager Thoughtbubb