Increasing a number in a custom user field by one every year.
Why not use a date field?
You can use this add-on to do the calculations: http://exponenciel.com/actaddons/actaddon.aspx?ID=111&ResID=Aff_glc0742
Of course!
You simply need to add a new 'calculated' field to your database. To do this you'll need to be logged in as the administrator, and you'll need to make sure you're the only user logged into your database. I also highly recommend you back up your data before making these changes.
First, go to Tools > Define Fields
Next up, choose the area of the program you want the new field to be (Contacts, Companies, Groups etc) and then click Create new field
Name the new field whatever you'd like, and set the field type to Calculated
Finally, on the next page, set the Calculated Field type to Date, choose the field you are calculating FROM, and select the formula - in this case Years since - then you can click finish.
Lastly, you'll just need to add the new field to your layout so it's visible!
