COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Event Studio => Topic started by: Jane on 28 May 2013 06:49:53 PM

Title: Scheduling a report on 15th through end of the month
Post by: Jane on 28 May 2013 06:49:53 PM
I need to run the report 1/day on the 15th, 16th ..... 28th....31st

Do I have to create 16 jobs (one for each day)?

I tried to create an event, but can't get Cognos to accept an expression to determine the day of the month.  What would be the correct syntax?

Thanks
Title: Re: Scheduling a report on 15th through end of the month
Post by: MFGF on 30 May 2013 05:30:32 AM
Hi,

How about:

extract(current_date, day) in (15, 16, 28, 31)

MF.