Skip to Content
S N

Dynamic default parameter last month

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 03, 2017 at 11:29 AM

    Got it working by following formula

    Concatenation(formatdate(RelativeDate(CurrentDate();-1;MonthPeriod);"MMMM");Concatenation("-";formatdate(RelativeDate(CurrentDate();-1;MonthPeriod);"yyyy")))
    Add comment
    10|10000 characters needed characters exceeded