date_add and macro dont work

User: "nceroni"
New Altair Community Member
Updated by Jocelyn
Hi everybody, I try to search in the forum and google for this, but I cant find the answer..

I'm trying to loop between dates, but the filter example box dont work when I try to put a macro variable in to date_add:

This is the code:

date_before([Fecha de Pago],date_add(date_parse_custom(%{max_date},"yyyy-MM-dd"),-%{iteration},DATE_UNIT_MONTH))
&&
date_after([Fecha de Pago],date_add(date_parse_custom(%{max_date},"yyyy-MM-dd"),-%{iteration}-12,DATE_UNIT_MONTH))

when I replace the "{%iteration}" with a number, the process work, but with the macro dont. The error was:

"The function date_add must have an argument of type 'integer' as 'second' argument.

How I can Fix that? How I can make the process iterate between dates?


Find more posts tagged with