"w" number of weeks between the two dates
"ww" number of calendar weeks (Sundays) between the two dates
The result between the two would differ if you have less than 7 days
with a Sunday that doesn't fall on the first date.
I think posted a function to return the number of weekdays (as you
define it) on this list a few days ago:
function WeekdaysBetween(date1,date2){
var out = 0;
var tmp = "";
if(DateCompare(date1,date2) GT 0){
tmp = date1;
date1 = date2;
date2 = tmp;
}
if(DayOfWeek(date1) IS 1) date1 = DateAdd("d",-2,date1);
if(DayOfWeek(date1) IS 7) date1 = DateAdd("d",-1,date1);
if(DayOfWeek(date2) IS 1) date2 = DateAdd("d",+1,date2);
if(DayOfWeek(date2) IS 7) date2 = DateAdd("d",+2,date2);
out = DateDiff("d",date1,date2);
if(DayOfWeek(date2) LT DayOfWeek(date1)) out = out - 2;
out = out - (out\7)*2;
return out;
}
Pascal
> -----Original Message-----
> From: Jim McAtee [mailto:[EMAIL PROTECTED]
> Sent: zaterdag 5 juni 2004 2:52
> To: CF-Talk
> Subject: Is this a DateDiff() bug?
>
> ColdFusion 5:
>
> <cfoutput>
> <pre>
> DateDiff("d", "5/1/2004", "5/31/2004") = #DateDiff("d",
> "5/1/2004", "5/31/2004")# DateDiff("w", "5/1/2004",
> "5/31/2004") = #DateDiff("w", "5/1/2004", "5/31/2004")#
> DateDiff("ww", "5/1/2004", "5/31/2004") = #DateDiff("ww",
> "5/1/2004", "5/31/2004")# </pre> </cfoutput>
>
> Gives:
>
> DateDiff("d", "5/1/2004", "5/31/2004") = 30 DateDiff("w",
> "5/1/2004", "5/31/2004") = 4 DateDiff("ww", "5/1/2004",
> "5/31/2004") = 4
>
> The docs state that "w" should return the number of
> "Weekdays", which I take to mean the number days between the
> two dates, minus days that fall on a weekend.
>
> By poking different dates into the two fields I can get the w
> and ww results to differ by one, but most often they're the same.
>
> Bug?
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
