Default current Month and Current year on Value prompt:

Solution:

 

Pq_Date (Prompt Query):

d_Date_Month_Use: Expression: month([Date])

d_Date_Month_Display: Expression: left(monthname([Date]),3)

d_Date_Year_Display: Expression: year([Date])

 

d_Date_Month_Final_Use: Expression:

Case
When [d_Date_Month_Use] = month(current_date) then 0
Else([d_Date_Month_Use])
End
 

d_Date_year_Final_Use: Expression:

Case
When [d_Date_Year] = year(current_date) then 0
ELse([d_Date_Year])
End

-----------------------------------------------------------------------------

Now add 2 Drop down Prompts: (Month; year) :

Month: Drop down prompt(Value Prompt)
Use Value: d_Date_Month_Final_Use

Display Value: d_Date_Month_Display

Add Default Selections: 0

 

Year: Drop down prompt(Value Prompt)

Use Value: d_Date_year_Final_Use

Display Value: d_Date_Year_Display

Add Default Selections: 0

  -----------------------------------------------------------------------------------

Main Query— add filter:

([d_Date_Month_Final_Use] = ?P_ Month?) and ([d_Date_year_Final_Use] = ?P_ Year?

---------------------------------------------------------------------------------------