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

how to determine all friday in a year

Started by Universe14, 16 Nov 2009 11:28:04 PM

Previous topic - Next topic

Universe14

Hi,

I would like to ask for some help on how to determine all the fridays in a year in cognos report studio or in a express editor.

replies will be much appreciated.

Thanks!

Sreeni P

Hope it will works....


_day_of_week ( date_exp, integer )

it will Returns the day of week ( between 1 and 7), where 1 is the first day of the week as indicated by
the second parameter(between 1 and 7, 1 being Monday and 7 being Sunday).