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

Arbitrary Date Calculation

Started by jmills, 20 Jun 2012 06:09:58 PM

Previous topic - Next topic

jmills

I'm working on a report where the user would like to select a date, either today or future date, and calculate a person's age based on that date. 

The challenge i'm running into is identifying the necessary Data Item to use.  Is there a way to prompt the user on a prompted date, and not necesarily a date from the report package?

??? = ?Prompt date?

Thanks in advance.

MFGF

You don't need a specific filter to generate a prompt - a data item will do. Try defining a data item in your query with the expression ?Prompt date?, then add a date prompt to your report and set it to use the existing parameter ?Prompt date?. Then you can add your calculation for age and display this in your report. This should hopefully give you what you need.

Regards,

MF.
Meep!

jmills