Hi all,
is the datepart "w" not supported anymore ?? or is it just buggy ?
IMHO #dateadd("w", 1, now())# should return this time monday but it
doesnt't
Very weird ...
Allan Pichler
~~
Structure your Col
I have never used these functions much.
The syntax looks just like the help files.
Can I use the DateAdd function in a CFSET?
I get this error:
Error Diagnostic Information
An error occurred while evaluating the expression:
TodayPlus1 = DateAdd(d, 1, Today)
Error near line 24, column
u forgot to nest the DATEPART fucntion to evaluate the "w"
-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 3:59 PM
To: CF-Talk
Subject: DateAdd
Hi all,
is the datepart "w" not supported anymore ?? or is it just bu
ok, what obvious deal have I missed?
#finaldate#
I get an error resolving "d" it says...trying to find the datee two days
from today and delete everything from the database later from that date
back.
Eric J Hoffman
Director of Internet Development
Small Dog Design, LLC
www.smalldogdesign.co
Hi,
I'm having an annoying problem with DateAdd.
I'm hosted in the States and I'm in the UK so to fix that in my Applicatin.cfm
I've put:
That is fine and i've used it forever.
To find the current edition (month) of my magazine I use:
I want to have an image on m
Mostly for Tony Weeg's benefit, this turned up on the BACFUG list and
it answers Tony's question about the dateAdd() bug.
Begin forwarded message:
> From: Tariq Ahmed <[EMAIL PROTECTED]>
> Date: Fri Jul 18, 2003 08:14:45 US/Pacific
> To: [EMAIL PROTECTED]
> Subject:
-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 7:29 AM
To: CF-Talk
Subject: DateAdd function
I have never used these functions much.
The syntax looks just like the help files.
Can I use the DateAdd function in a CFSET?
I get this
Sent: Friday, May 24, 2002 9:30 AM
Subject: RE: DateAdd function
>
>
> -Original Message-
> From: Yves Arsenault [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 24, 2002 7:29 AM
> To: CF-Talk
> Subject: DateAdd function
>
> I have never used these functions much
No problem
-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 7:38 AM
To: CF-Talk
Subject: Re: DateAdd function
Ah man,
The Quotes weren't in the help file I looked at, and my brain didn't
click
in to trying them.
Cu
0
Portland, OR 97205
503.221.9860 ext. 111
http://isitedesign.com
**
-Original Message-
From: Eric J Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 5:24 PM
To: CF-Talk
Subject: dateadd problem
ok, what
]]
Sent: Thursday, December 20, 2001 7:26 PM
To: CF-Talk
Subject: RE: dateadd problem
You'll want to put quotes "d" around the d. It's looking at d as a
varialble without them.
t
**
Tyler M. Fitch
Certified
How about a dateSubtract function? Does anyone know it there is a function similar to the dateAdd Function that instead adding specified number of days or months it actually subtracts a specified number of days or months. I checked cflib.org but I could not find anything.
Dwayne Cole, MS in
UKTodayDate is not a function, but a variable:
nextEdition = lcase(DateFormat(DateAdd("m", 1, UKTodayDate),""))
> -Original Message-
> From: Stuart Kidd [mailto:[EMAIL PROTECTED]
> Sent: 23 December 2004 13:39
> To: CF-Talk
> Subject: DateAdd pr
> lcase(MonthAsString(month(UKtodayDate()#>
Hi Saturday,
Noticed you've got an extra set of arguments after UKtodayDate which
could be your problem, try:
Also in the UK and always on the look out for a good host, have you
found a US Host that's easy to deal with from here? Reply off list
;
>nextEdition = lcase(DateFormat(DateAdd("m", 1, UKTodayDate),""))
>
>> -Original Message-
>> From: Stuart Kidd [mailto:[EMAIL PROTECTED]
>> Sent: 23 December 2004 13:39
>> To: CF-Talk
>> Subject: DateAdd problems.
>>
>&g
Hi Ant,
I just got the solution from Pascal, thanks anyhow.
I use www.hostmysite.com, i find them really good actually - i've been with
them about 3 or 4 years. I've tried other US firms in the past like Interland
but their customer support was really bad. I often get replies to my emails
wi
DateAdd takes a date as 3rd argument, not the name of the month
Pascal
>
> lcase(MonthAsString(month(UKtodayDate>
>
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.c
You can supply negative numbers to DateAdd...
DateAdd("d", "-1", Now())
Subtracts a day from Today.
Jeff
- Original Message -
From: Dwayne Cole
To: CF-Talk
Sent: Wednesday, October 15, 2003 4:32 PM
Subject: DateSubtract Like DateAdd?
How about a d
just make the interval negative. dateAdd("d", -14, now())
-Original Message-
From: Dwayne Cole [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 4:33 PM
To: CF-Talk
Subject: DateSubtract Like DateAdd?
How about a dateSubtract function? Does anyone know it
WOW Kinda of embarrasing. Thanks!
-- Original Message --
From: "Barney Boisvert" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 15 Oct 2003 16:39:26 -0700
>just make the interval negative. dateAdd("d", -14, no
I remember asking the exact same question, so if embarassing, you're
certainly not alone. ; )
-Original Message-
From: Dwayne Cole [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 4:45 PM
To: CF-Talk
Subject: RE: DateSubtract Like DateAdd?
WOW Kinda of embarr
, 2003 7:45 PM
To: CF-Talk
Subject: RE: DateSubtract Like DateAdd?
WOW Kinda of embarrasing. Thanks!
-- Original Message --
From: "Barney Boisvert" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 15 Oct 2003 16:39:26 -0700
Why does this work:
#PreserveSingleQuotes(searchDate)#
and not:
#PreserveSingleQuotes(DateAdd("m",3,now()))#
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and rela
I run a graph on a server in a different time zone. I'd like to modify the
times (hour only) by adding two hours. However, the query is grouped by day
and hour, then fed into CFGRAPH.
Anyone know if this can be done without modifying the data in the table?
Thanks!
Jeff
__
Hello All,
I wonder if someone out there can help me? I am having a horrible time with
the dateadd function using UK dates, I am acquiring a date value and
increment values from a form and then incrementing other form values with
this date and increment values. My problem seems to occur when
:
select StartDate, this, that
from tblName
where StartDate between #createODBCdate(Now())# and DateAdd("d", 7,
'tblName.StartDate')
I keep getting errors with various combinations of this that I have tried.
Any ideas how to get this done? I assume that I can use SQL date functions
t
Try this...
#nextq#
You should get (if you try this in July) the month returned as "10"...
No problem.
However.. Try this...
#nextq#
And you get the month returned as "6". Huh?? I thought quarters were
January, April, July and October? How does one get a "6" as the first
month in
Hi,
I am trying to create two separate dates, the present date and the date a week later,
as today is 06/02/02 that is one date then next one is 13/02/02.
The problem I am having is with formatting the second date. As I am in the UK I want
the format of the dates to be dd/mm/yy, but when I go
On Wednesday, September 25, 2002, at 03:53 , Brian Thornton wrote:
> Why does this work:
>
> #PreserveSingleQuotes(searchDate)#
> and not:
> #PreserveSingleQuotes(DateAdd("m",3,now()))#
I think everyone is coming to the conclusion that you can't put fu
> I run a graph on a server in a different time zone. I'd like
> to modify the times (hour only) by adding two hours. However,
> the query is grouped by day and hour, then fed into CFGRAPH.
>
> Anyone know if this can be done without modifying the data in
> the table?
You could modify the dat
> Sent: Thursday, March 21, 2002 2:01 PM
> To: CF-Talk
> Subject: dateadd with grouped query and cfgraph
>
>
> I run a graph on a server in a different time zone. I'd like
> to modify the
> times (hour only) by adding two hours. However, the query is
> grouped by
I figured it out - sorry for the bother. here's the fix:
blah blah blah...
DATEPART(hh, DATEADD(hh, 2, who.ActionDateTime)) AS HOURS
GROUP BY DATEPART(hh, DATEADD(hh, 2, who.ActionDateTime))
blah blah blah
mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 3:01 PM
To: CF-Talk
Su
Adam, Dave, and anyone who answers before this hits the list - thanks for
the assist!!
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 3:13 PM
To: CF-Talk
Subject: RE: dateadd with grouped query and cfgraph
Not exactly sure how your db
You could modify your query object before sending it to .
EXAMPLE:
SELECT Date, Value
FROM TableName
ORDER BY Date
QuerySetCell(graphData, "Date", DateAdd("h", 2, graphData.Date),
graphData.CurrentRow);
HTH ^_^
--
SCOTT VAN VLIET
over the query and do your dateadd to the date field before you
feed the query to cfgraph
- Original Message -
From: "Jeff Beer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 3:00 PM
Subject: dateadd with grouped que
To: CF-Talk
:> Subject: Dateadd function problems with UK locale!
:>
:>
:> Hello All,
:>
:> I wonder if someone out there can help me? I am having a
:> horrible time with
:> the dateadd function using UK dates, I am acquiring a date value and
:> increment values
> select StartDate, this, that
> from tblName
> where StartDate between #createODBCdate(Now())# and DateAdd("d", 7,
> 'tblName.StartDate')
Here you are testing to see if StartDate is between Now and StartDate + 7
Days.
You should be testing to see if Now is bet
Just one 'H'
#DateAdd('H', '3', Now())#
-Original Message-
From: Walker, Matthew [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 05, 2000 6:55 PM
To: CF-Talk
Subject: RE: SQL DateAdd function - how do I?
> select StartDate, this, that
> fr
lk" <[EMAIL PROTECTED]>
Sent: Wednesday, February 06, 2002 7:59 PM
Subject: Problem with DateFormat when using DateAdd
> Hi,
>
> I am trying to create two separate dates, the present date and the date
a
week later, as today is 06/02/02 that is one date then next one is 13/02
Does anyone use DateAdd in ColdFusion before and tell me why I can not use
the return
value from DateAdd to compare with date field in a table?
My problem is:
and it does print out endDate as date, however,
when I
dDate,"dd-mmm-yy")#';
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
-Original Message-
From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 12:58 PM
To: CF-Talk
Subject: DateAdd in CF and Date Field in Oracle.
haracters to find a phonetic equivalent "kokou
kole", translating into "happiness in the mouth."
-Original Message-
From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 10:58 AM
To: CF-Talk
Subject: DateAdd in CF and Date Field in Oracle...
, July 28, 2001 11:07 AM
Subject: DateAdd Strangeness? (Or is it me?)
> Try this...
>
>
>
>
> #nextq#
>
>
> You should get (if you try this in July) the month returned as "10"...
> No problem.
>
> However.. Try this...
>
>
>
>
enough.. If you use "Quarter(now())" it returns the number based
on calendar quarters. So if you're trying to modify a date to get the
next "calendar" quarter.. It would be simple to use the dateadd to add a
quarter and voila! But.. Sadly it doesn't work that way
Don't forget, some fiscal years start and end in February. Therefore, fiscal
1Q 2001 would be Feb-Apr.
- Original Message -
From: "Lee Fuller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, July 28, 2001 2:46 PM
Subject:
- Original Message -
From: "Lee Fuller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, July 28, 2001 12:46 PM
Subject: RE: DateAdd Strangeness? (Or is it me?) --it's you!!
> Yes.. But... (isn't there always one?? ;
46 matches
Mail list logo
