COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jd on 08 Mar 2011 08:23:55 AM

Title: How to get currnet month in date prompt
Post by: jd on 08 Mar 2011 08:23:55 AM
Hi I have a start date and end date value prompts in my report

both dates are based on Date data item in my query.
I have future dates in my data up to Sep 2011.
but when I run my report I have to show up current month/year(ex: Mar 2011) by default.
how can  I achive this any idea??
Title: Re: How to get currnet month in date prompt
Post by: PRIT AMRIT on 08 Mar 2011 08:58:28 AM
Do you want your report to be filtered by Current Date only or also you would like to display the Current Dates in your value prompt by default?
Title: Re: How to get currnet month in date prompt
Post by: jd on 08 Mar 2011 12:47:59 PM
Hi Prit,

I wold like to dispaly current date in my value prompt by default. Means when I run the report my dates value prompt needs to show up Mar 2011. this is a optional drop down box. user can select any date to filter the date
but first when I run it has to show current month and year. (month and year format I have in my query data item)