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
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
> 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
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:
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
> 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
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
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
8 matches
Mail list logo