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

Display fixed date

Started by tolu, 18 Aug 2010 07:22:40 AM

Previous topic - Next topic

tolu

How do I display from date and to date without using a parameter. I have a monthly report job that runs each month for data from the 1st to last day of each month. I have hard coded the beginning of month and end of month date into my report.  How do I display this on the report heading to show this date range(1st of month to last of month). 

Thanks!

Chris_

Create two query expressions like...

minimum(date) and maximum(date)

This will display the first/last dates of the range?

tolu

Thank You. The issue is that I want to display the entire month that the report is ran for regardless if there is any data for the last day of the month.  Using the maxdate will only give me the last data date.  I need the last day of the month regardless.