Skip to Content
0

Dynamic default parameter last month

Aug 03, 2017 at 10:03 AM

38

avatar image
Former Member

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
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Aug 03, 2017 at 11:29 AM
0

Got it working by following formula

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