Dynamic date prompt range-show last 5 years data of UserResponse

[Maiden]

Hi
How can I create a universe filter object which can make use of a UserResponse to a prompt for a date entry?

Example: I open a report; as report prompt: year entry; the entered year is joined with a calculation (>= [User-Response] -5) --> Example: User entry: 1999
Now all records are shown from 1994 until 1999
-We do not want the Between to be shown
-the user should only make a year entry, because in the report no data in the range of more than five years previous are to be shown.

I tried using:
@Select(Test Objects\Year2) BETWEEN @Prompt('ENTER YEAR','N',{'1993','1994','1995'},mono,free) AND (@Prompt('ENTER YEAR','N',{'1993','1994','1995'},mono,free)-2)

gives 'No data to fetch'.

Any ideas?
Maiden

 

[eldkir]

Using your database's syntax, create a Universe Object called "Year-5" and set your filter to be "Year" between "Year-5" And Prompt (Enter Year

*To get "Year-5" into the filter, choose "Select an Object"

I hope this works for you!

Eldad