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 give current date as default selection in date prompt

Started by tushar gaurav, 28 Dec 2021 02:30:16 AM

Previous topic - Next topic

tushar gaurav

Hi,

In my report there is no prompt page and there is a date prompt in the report page itself along with a list report.
I need to give "last date of the previous month" as default selection in the date prompt and when I execute the report the list report should show the data as per "last date of the previous month".
I have javascript to show "last date of the previous month" , but its working when the date prompt is in prompt page.
When I add the date prompt in the report page and execute the report , I am getting Date popup asking for date selection.
Can you please help me.

Thanks,
Tushar

dougp

Make the filter/parameter optional:

#prompt ('MyDateParameter', 'date', timestampMask (_last_of_month (_add_months ($current_timestamp, -1)), 'yyyy-mm-dd'))#

tushar gaurav