LiveDocs Comments - coldfusion - 6.1 - htmldocs - functi58.htm

coldfusion/6.1/htmldocs/functi58.htm

redtopia — 2006-10-23T09:42:00

startDate = CreateDateTime (2006, 10, 13, 8, 0, 0); // Oct. 13, 2006, 8:00 AM
endDate = CreateDateTime (2006, 10, 14, 0, 0, 0); // Oct. 14, 2006, 12:00 AM
ctDays = DateDiff ("d", startDate, endDate); // equals 0

endDate = CreateDateTime (2006, 10, 14, 8, 0, 0); // Oct. 14, 2006, 8:00 AM
ctDays = DateDiff ("d", startDate, endDate); // equals 1

Day differences are calculated by diffing the hours and then dividing by 24. I initially thought this function would tell me that there is a 1 day difference in my first example.

coldfusion/6.1/htmldocs/functi58.htm

TomChiv — 2005-03-10T01:39:08

I agree with clementi, it is not clear when dateDiff will return negative or positive results, and the example requires dates to be entered, so it has to be run.
Something you could just look at and see 'ah right' would be better.
Maybe a table with a few example values for the two dates and the result codes.

coldfusion/6.1/htmldocs/functi58.htm

halL — 2004-08-10T12:51:09

guintato is correct.
DateDiff ignores the time when calculating differences in units greater than days.
We have filed bug number 56889 against this behavior.

coldfusion/6.1/htmldocs/functi58.htm

guintato — 2004-08-08T12:01:19

It seems to me that DateDiff doesn't consider the time when calculating years (similar results occur for months, and weeks):

dtCompDate = CreateDateTime(2002,11,5,17,45,0);
dtToday = CreateDateTime(2004,11,5,17,44,0);
iYears = DateDiff("yyyy",dtCompDate,dtToday);

Compare Date: #DateFormat(dtCompDate,"mmmm d, yyyy")# #TimeFormat(dtCompDate,"h:m tt")#

Today's Date: #DateFormat(dtToday,"mmmm d, yyyy")# #TimeFormat(dtToday,"h:m tt")#

The number of years between these dates is #iYears#

Expected answer is 1

Has anyone else encountered this problem, and if so how did you resolve it? Comments will be greatly appreciated.

coldfusion/6.1/htmldocs/functi58.htm

2004-08-03T04:34:37

I used this code to test:

setlocale("dutch (standard)");
writeoutput(DateDiff('s', CreateDateTime(1970,1,1,0,0,0), CreateDateTime(2004,6,6,0,0,0)));

Results:
CF5: 1086480000
CFMX unpatched: 1086476400
CFMX with hotfix 53813: 1086476400

There's still 1 hour time difference

coldfusion/6.1/htmldocs/functi58.htm

2004-08-03T03:39:53

Installed the hotfix, there's still a 1 hour time difference for datediff between CF5 and MX server.

coldfusion/6.1/htmldocs/functi58.htm

jrunrandy — 2004-03-24T06:35:41

Go to http://www.macromedia.com/support/coldfusion/ts/documents/duplicate_hotfix.htm to get a hotfix that addresses the daylight savings time bug.

coldfusion/6.1/htmldocs/functi58.htm

GreyLurk — 2004-03-19T16:04:47

This error arises from Daylights Savings time ( There are only 23 hours between 4/4/2004 and 4/5/2004, so it doesn't get counted as a whole day ). The Round( DateDiff ('h'... ) / 24 ) works well, though it's annoying that this hasn't been hotfixed yet.

coldfusion/6.1/htmldocs/functi58.htm

spindlenine — 2004-03-19T13:27:05

Somebody posted a very helpful function on one of the other forums. This function returns the number of days between two dates, and solved the problem I was having with DateDiff().

hint="This function fixes a bug in the 1.4.2 JVM that causes DateDiff to not
work for certain dates (4/07/2003 or 4/5/2004 or 4/4/2005). I discovered
this on the Macromedia LiveDocs for DateDiff in CF 6.1, after Joe found
an issue with the vacpac submit process that occured for April dates only.

This function returns the number of days between one date and another."
returntype="numeric">

coldfusion/6.1/htmldocs/functi58.htm

clementi — 2004-01-07T14:34:28

In the description above, how about this instead: "Subtracts _date1_ from _date2_ and returns the result in units of _datepart_."

coldfusion/6.1/htmldocs/functi58.htm

jrunrandy — 2003-09-11T11:10:08

This is bug 53252 and seems to be related to the 1.4.2 JVM.

coldfusion/6.1/htmldocs/functi58.htm

CFGumby — 2003-09-11T09:56:01

Datediff seems to calculate the
wrong number of days if the
dates span 4/07/2003 or
4/5/2004 or 4/4/2005 and
probably more. (In 6.1 only.)

Date1	Date2	X	Days Diff
#DateFormat(Date1,"mm/dd/yyyy")#	#DateFormat(Date2,"mm/dd/yyyy")#	#x#	#DaysDiff#