Date Comparison Text Prompt

[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)