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 get currnet month in date prompt

Started by jd, 08 Mar 2011 08:23:55 AM

Previous topic - Next topic

jd

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??

PRIT AMRIT

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?

jd

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)