//
// Return the number of weekdays in a date range, inclusive
// of the beginning and end dates.
//
function Workdays(date1, date2) {
var adjust = 0;
var s = IIf(DateCompare(date1, date2) gt 0, 'date2', 'date1');
var e = IIf(DateCompare(date1, date2) gt 0, 'date1', 'date2');
var ws = DayOfWeek(s);
var we = DayOfWeek(e);
if (ws eq 1 or ws eq 7)
adjust = (7 - ws + we - 1) mod 6;
else if (we eq 6 or we eq 7)
adjust = 7 - ws;
else
adjust = ((5 - ws + we) mod 5) + 1;
return ((e - s) \ 7) * 5 + adjust;
}
----- Original Message -----
From: "Pascal Peters" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, June 05, 2004 4:06 PM
Subject: RE: Is this a DateDiff() bug?
> Yeah, I wrote it to help someone out with a specific problem. Glad it
> can give you something to start with.
>
> Pascal
>
> > -----Original Message-----
> > From: Jim McAtee [mailto:[EMAIL PROTECTED]
> > Sent: zaterdag 5 juni 2004 20:58
> > To: CF-Talk
> > Subject: Re: Is this a DateDiff() bug?
> >
> > OK. I see that now in the documentation. Doesn't make much
> > sense to me, but I'm guessing there's some use for that behavior.
> >
> > I've looked at your function and it's close to what I'm
> > looking for, but I need to modify it to make it inclusive of
> > the end dates.
> >
> >
> >
> > ----- Original Message -----
> > From: "Pascal Peters" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Saturday, June 05, 2004 2:14 AM
> > Subject: RE: Is this a DateDiff() bug?
> >
> >
> > > Not a bug, look in the help:
> > > "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]
