date_add and macro dont work

nceroni

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?

haddock

Hi,

Macros take the format %{iteration} rather than {%iteration} as you have. That would do it.

Best

H

nceroni

Sorry, I have %{iteration}, but still dont working.

What can I do?

nceroni

I Solved the issue. I put the expression in the "Generate Macro" box, and then I convert to date in the filter box.

Thanks.