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

Optional Date Range, but if start date, then no latest date

Started by yossiea, 11 Nov 2013 09:30:51 AM

Previous topic - Next topic

yossiea

Hi,
I inherited a report with several date range prompts (I usually go for start/end dates).
All prompts are optional. The requirement is that when a range is chosen, then the date can't be OracleNoDate (2999-dec-31), even if latest date is chosen.
Is there a simple solution other than converting to start/end date and putting in some calculations?
I don't think I can do a max(prompt) in the filter.

Thanks