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

Date Comparison Text Prompt

Started by adpruett, 01 Dec 2008 12:55:49 PM

Previous topic - Next topic

adpruett

I am comparing 2 dates.... current_date - [Release Date]... to create an aging data item

I want to then create a text prompt that includes only days while using that aging data item.

How can I create a text prompt that uses only days when writing my filter in the query?

Right now, my filter is as follows.... [Aging] >= ?Aging?

nonooo

are you using dimensionnaly datasource or sql datasource ?

in sql you must have a prebuilt function... in dimensionnaly you have function head (<set> , <nb>) where <set> will be the day level and nb is your ?aging? prompt (I do not say this is the proper way to do it, but it should work)