If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Extract weekdays in Previous Month

Started by kbasha2004, 28 Feb 2008 01:57:45 PM

Previous topic - Next topic

kbasha2004

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