date_add and macro dont work

nceroninceroni Member Posts: 3 Contributor I
edited November 2018 in Help
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?


  • Options
    haddockhaddock Member Posts: 849 Maven

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


  • Options
    nceroninceroni Member Posts: 3 Contributor I
    Sorry, I have %{iteration}, but still dont working.

    What can I do?
  • Options
    nceroninceroni Member Posts: 3 Contributor I
    I Solved the issue. I put the expression in the "Generate Macro" box, and then I convert to date in the filter box.


Sign In or Register to comment.