Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 04, 2008 8:02 AM
To: cf-talk
Subject: RE: CF DATEDIFF Function
Exactly. An entire day must expire before it can be counted. To expand
that, an entire time period must expire before it can be counted.
This includes
.
Mike
-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Monday, November 03, 2008 8:39 PM
To: cf-talk
Subject: Re: CF DATEDIFF Function
Azadi Saryev wrote:
because your server time is different from your computer's time? your
well there's that or that dateDiff
As others have pointed out, it's an issue of Whole Days. Think of it this way,
you are testing number of days between Now() and tomorrow's date, right? Well,
Now() includes the time, so not just '11/04/2008', but right now it's
'11/04/2008 08:06 EST'. When you test that against '11/05/2008',
because your server time is different from your computer's time? your
server may be in a timezone where it is already 'tomorrow' while where
you are it is still 'today', so now() on the server will return your
'tomorrow' date...
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
LSD 4Me
Azadi Saryev wrote:
because your server time is different from your computer's time? your
well there's that or that dateDiff returns results for *whole* days (or
whatever). try using hours.
~|
Adobe® ColdFusion® 8 software 8
Problem is that im not storing time with the date... Also, the return value is
'0' for today, and tommorow...i.e
Today
#datediff(d,now(),now())#
Tommorow
#datediff(d,now(),now()+1)#
I managed to resolve this with another solution...
cfset currentdate = #dateformat(now(),'mm,dd,')#
it's a bad idea to store dates in your db as text. store them as dates.
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
LSD 4Me wrote:
Problem is that im not storing time with the date... Also, the return value
is '0' for today, and tommorow...i.e
Today
#datediff(d,now(),now())#
7 matches
Mail list logo