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]
