How to pick the data form DB from available data

[inu]

Hi Team,

I am using filter for time as

[Agreement Fact - Monthly].[Time Dimension(Fiscal Calendar)].[Month Key] between #prompt('Par_From_MonthYear', 'token',  'to_char (_add_months(current_date,-7), ''YYYYMM'')')# and #prompt('Par_To_MonthYear', 'token',  'to_char (_add_months(current_date,-5), ''YYYYMM'')')#

I want to use a function or any possible statement in place of current_Date, so that report will fetch the available data by default.


Regards,
Inam

[BigChris]

I don't understand - what do you want in place of current_date?