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