COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Universe14 on 16 Nov 2009 11:28:04 PM

Title: how to determine all friday in a year
Post by: Universe14 on 16 Nov 2009 11:28:04 PM
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!
Title: Re: how to determine all friday in a year
Post by: Sreeni P on 17 Nov 2009 10:37:13 AM
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).