Season year code?

[Thomas94]

Hi everyone,

I'm trying to combine the last 2 numbers from the year with the first character of the season.

For example: W19, S19

I'm usising following code:

='W'&max(right(num( Year(AddMonths(Today(),-1)) ),2))

This works, but when I create a variable of it, the result is "-".  Very strange because it's the same code as the expression.

My variable Seizoenscode :

='W'&max(right(num( Year(AddMonths(Today(),-1)) ),2))

The set analyses I want to use the variable: 

Seizoenscode={$(=$(vSeizoencodeCY))}

Anyone who knows how I can fix this?

thanks in advance

[vijetas42 · Accepted solution]

try to add variable as 'W'&max(right(num( Year(AddMonths(Today(),-1)) ),2)) without '=' sign and then you can use as $(variable)

[Thomas94]

It worked! Thank you for your help