DayOfWeek 1

[Roni1]

How can I count how many DayOfWeek in [1,7] for a date range? Example: How mayy Saturdays and Sundays from 1/1/08 tru 6/30/08?

 

[CR85user]

//Countwends
if dayofweek({date.field}) in [1,7] then 1 else 0

Sum on this through a running total or summary as appropriate to your needs (Read totals FAQ if unsure)

'J

 

[lbass]

This seems to work:

datevar start := {?start};
datevar end := {?end};
numbervar sats;
numbervar suns;
sats := datepart("ww",end,crSaturday)-datepart("ww",start,crSaturday);
suns := datepart("ww",end,crSunday)-datepart("ww",start,crSunday);
if dayofweek(start,CrSaturday) = 1 then
sats := sats +1 ;
if dayofweek(start, crSunday) = 1 then
suns := suns + 1;
"Sats: "+totext(sats,0,"") + " Suns: "+totext(suns,0,"")

-LB

 

[Roni1]

Thank you LB, that was right on the money!

I am sorry that took too long for me to respond.

Cheers!
Roni