COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: kbasha2004 on 28 Feb 2008 01:57:45 PM

Title: Extract weekdays in Previous Month
Post by: kbasha2004 on 28 Feb 2008 01:57:45 PM
Hi Pals,

I need to calculate WEEKDAYS (Excluding Satudays and Sundays)  in my report for PREVIOUS MONTH. I'm using Reportnet.
For Example:

In a week I'm able to extract weekdays as follows
(_day_of_week(Date column,7) between 2 and 6)

But I need to extract all weekdays in a previous month. Can somebody please help me out.

Thanks in advance!

Basha