You can use the following SQL to get the number of working days (not including sat and sun) of the current month
SELECT COUNT(TRUNC(SYSDATE,'MM') +(LEVEL-1)) AS BUSINESS_DAYS_IN_MT
FROM DUAL
WHERE TO_CHAR(TRUNC(SYSDATE,'MM') +(LEVEL-1),'D') NOT IN (1,7)
CONNECT BY LEVEL <=LAST_DAY(SYSDATE)- TRUNC(SYSDATE,'MM') + 1
Add this as a REPOSITORY VARIABLE and can be use in the reports for calculations |
0 comments:
Post a Comment