Using a variable in a set statement

[#1]

Hi all,

I could really use some help with making a script dynamical so that i wouldnt have to change it each year.

I created a variable named: vCurrentYear that defines the year in which we currently live.

Now im trying to substitute the 2015 into the formula but when i try it stops working?

SET fClaims_Jan_CY =     

if(Conditiemutatie_Vanaf >= Date#('01-01-2015')     
        

  for example:

SET fClaims_Jan_CY =     

if(Conditiemutatie_Vanaf >= Date#('01-01-($(vCurrentYear))')   (Doesnt work)  

[pokassov · Accepted solution]

Hi!

if(Conditiemutatie_Vanaf >= Date#('01-01-$(vCurrentYear)')

[Gysbert_Wassenaar]

You don't need that variable actually:

SET fClaims_Jan_CY = InYear( Conditiemutatie_Vanaf , today());