Season year code?

Thomas94 — Fri, 08 Mar 2019 12:49:15 GMT

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

Re: Season year code?

vijetas42 — Fri, 08 Mar 2019 13:54:04 GMT

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

Thomas94 — Mon, 11 Mar 2019 13:45:32 GMT

It worked! Thank you for your help