Hi experts,
i have the following script
FOR i = 0 to 12
LET vMonthT = MONTH(ADDMONTHS($(vToday),-$(i)));
LET vMonthN = NUM(MONTH(ADDMONTHS($(vToday),-$(i))));
LET vYearT= YEAR($(vToday));
//LET vYearT = YEAR(ADDMONTHS($(vToday),-$(i)));
SRDaysMonth:
LOAD
BRNO,
MONTHNAME(MAKEDATE($(vYearT),$(vMonthN),1)) as SALESMONTH,
SUM(SRDAYS) as SRDAYS
FROM
[\BRANCH_CALENDAR.qvd] (qvd)
WHERE EXISTS(BRNO) AND YEAR(BHDATE) = '$(vYearT)' AND MONTH(BHDATE) = '$(vMonthT)' AND
BHDATE < $(vToday)
GROUP BY BRNO;
Next i;
LET vMonthT =;
LET vYearT =;
LET vMonthN=;
from the above script how can i get SRDAYS for current month alone. (SRDAYS will vary according to the BRNO. it is nothing but the working days)
i have already set some variables to define current date,year,month......previous months,years.....
Please assist me in fixing this issue