Compare variable to result of addyears() in load script

[fzalexanderjohn]

Hello,

I have these two lines in my load script:

    if([Datum ab] <= date('$(vDatenStand)') and [Datum bis] >= date('$(vDatenStand)'), Betrag) as 'Betrag aktuell',
    if([Datum ab] <= date(addyears('$(vDatenStand))',-1)) and [Datum bis] >= date(addyears('$(vDatenStand))',-1)), Betrag) as 'Betrag VJ',

The first one works as intended, the second one doesnt.

The variable:

Let vDatenStand = today()-1;

How the data in the fields looks:

I tried it without the date() function as well. But I can't get it to work

[fzalexanderjohn]

I noticed the wrong ')' at (vDatenStand)) like 10 seconds after posting.. not enough coffee