I have a calculated field [Current Year] in Text Format:
which displays "2019" in Text Format.
But I also want to create a new Column with a calculated column that is next year (also in Text format as above)
I tried (logically I thought)
But it gave 2,020!! NOT "2020".
Please can someone suggest the Calculation for Next Year in Text Format. So it appears as (in this case) 2020.
Thanks in advance.