Labeling of fields

[#1]

Hi all

I try to label a field with Actual and a via Formula generated Year

='Act ' & Year(Today())-1

but it doesn't work.

Can you help me with that?

Thanks in advance.

Oliver

[ashfaq_haseeb · Accepted solution]

Hi,

Try like this

='Act ' & Year(Today()-1)

Regards

ASHFAQ

[morganaaron]

Wrap the Year(Today())-1 in brackets and it should!

[maxgro]

add ()

='Act ' & (Year(Today())-1)

[#5]

hi,

use it

='Act   '   & year(Today()-1)

Regards

Vimlesh

[fvelascog72]

Maybe you want this:

'Act'& (Year(Today())-1)

[Anonymous]

workaround does the job (in my case)

='Act ' & max(year(today())-1) works

[#8]

Hi all

Thanks for your help!

[morganaaron]

No worries - just a note, Ashfaq's answer will give you the year for yesterday - if you want the previous year for today, then use the formula given by myself and Massimo!

[rubenmarin]

Massimo and Aaron were right, concatenation operator has the same priority as the addition operator, wich is in equal priority than the substraction operator, and the '&' used to concatenating is before the '-' used to substraction because in equal priority is evaluated left to right.

In example, if the expression was "='Act ' & Year(Today())*2" it will do first the multiplication and the concatenation (as multiplication has more priority than addition)

In that expression you need to add parentheses to specify to do first the substraction and then the concatenation.