Query Filter Function?

[Former Member]

when I make a report, I want it to chose the date in "Query Filters` place. this option is going to be between and i am going to chose one of them by myself and the other is going to be chosen 4 months before which I chose. for example, I chose june as a filter, it should give me the february automatically based on my function. this kind of function can be written filter which is in "Query Filters"?????? whenever I write =currentMonth() in filter place, It brings up the data based on the last month.

[Former Member]

Hello,

Your post is a little difficult to understand, but it sounds like you want to do something like go back, for example 4 months from the date you enter in a prompt when running the report? So if you enter June 1, you want to see data between Feb 1 and June 1?

You can easily create such an object in your Universe with DateAdd function. That can then be used in query filter. I don't think you can create such a filter on the fly in query filter in Webi. You can on the report as a variable, but not sure that would help.

Thanks!