How can i substract Year field from Current Year?

[#1]

Hi All,

I have a field Year.

Year:

2005

2006

2007

How can i create another field by substracting each value of Year Field from the Current Year.

How i need is

2012-2005

2012-2006

2012-2007

in a seperate field.

Thanks in advance.

Regards

Kumar

[#2 · Accepted solution]

use this:

Load Year, year(today())-Year as NewYearfield