I tell ya, I can make some pretty ugly formulas....But they work so I'm happy!!!
Here's what I came up with:
local numbervar nSatorSun:=nSatorSun + (if 2<={@Days in Date Range}
then (if weekdayname(dayofweek(dateadd('d',+1,{@DateRangeMin})))='Saturday'
or weekdayname(dayofweek(dateadd('d',+1,{@DateRangeMin})))='Sunday'
then 1
else 0)
else 0);
Then do one incrementing compare number to Days in Date Range and the dateadd number by 1 until 31 days are represented (the report will only be run for a maximum of 1 month).
Days in Date Range=datediff('d',DateRangeMin, DateRangeMax)+1
It's ugly, but like I said, it works and gives me the conunt of Saturdays and Sundays.
PLEASE!!!!! If anyone else has an easier way, clue me in on it.
Thanks.
IP Logged