number of working days in the previous month

[e11a]

Hello.

Is there a way to calculate the number of week days there were in the previous month?

Thanks,

E.

 

[synapsevampire]

Here's a formula that should work:

whileprintingrecords;
numbervar days := day(cdate(year(currentdate),month(currentdate),1)-1);
numbervar x;
numbervar daycounter := 0;
datetimevar PrevMonth := dateadd("m",-1, currentdate);
for x:= 1 to days do(
if dayofweek(cdate(year(prevmonth),month(prevmonth),x)) in [2 to 6] then
daycounter := daycounter+1
);
Daycounter

-k

 

[e11a]

Thanks synapsevampire. That's brilliant.

E.

 

[Reebo99]

or :

DateVar TempDate := Minimum(lastfullmonth);
NumberVar DayCount := 0;
While TempDate <> Maximum(lastfullmonth)+1 do
(If not(dayofweek(TempDate) in [7,1]) then DayCount := Daycount + 1;
TempDate := TempDate + 1);
DayCount;

Reebo
Scotland (Sunny with a Smile)