formula for counting different days 1

[draacor]

what is the formula for counting the number of days during a specific date range. For example i want to count how many mondays there were during the date range so that i can take that number and use it to average out the number of calls we get on mondays.

 

[CoSpringsGuy]

end date - start date

Ex:
date("2001-01-01")
-
date("2000-02-01")

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[CoSpringsGuy]

scratch that .....

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[CoSpringsGuy]

didnt read it right the first time .. my apologies ... this should work

local numbervar a;
local numbervar b:= enddate-startdate;
local numbervar c;

for c := 0 to b do
(
if dayofweek(startdate+c) = 2 then // replace as needed (2 is monday, 3 is Tuesday etc...)
a := a +1
);
a


_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[draacor]

awesome it works, thanks for your help. I really appreciate it!

 

[lbass]

From Ken Hamady's formula examples:

datediff("ww",{startdate}-1,{enddate},crMonday)

-LB