Dynamic default parameter last month

[former_member185138]

Hi Experts,

Requirement is to create a dynamic filter on IDT to select App out Mon Year = Last Month Mon Year.

I created a IDT parameter as per the attached image and following formula:

Concatenation(Formatdate(RelativeDate(CurrentDate(); 1; MonthPeriod);"Mmmm");(Concatenation("-";YEAR(RelativeDate(CurrentDate()); 1; MonthPeriod))))

But getting following error:

Semantic error: line 1 position 101: missing arguments for the function 'RelativeDate' 

Semantic error: line 1 position 96: too many arguments of 'YEAR' operation: expected YEAR found 1 

Semantic error: line 1 position 78: unexpected argument data type '2' in position Concatenation for the function 'Concatenation' 

Semantic error: line 1 position 0: unexpected argument data type '2' in position Concatenation for the function 'Concatenation

[former_member185138 · Accepted solution]

Got it working by following formula

Concatenation(formatdate(RelativeDate(CurrentDate();-1;MonthPeriod);"MMMM");Concatenation("-";formatdate(RelativeDate(CurrentDate();-1;MonthPeriod);"yyyy")))