Community
Showing results for 
Search instead for 
Do you mean 
Reply

Increasing a number in a custom user field by one every year.

New Member
Posts: 6
Country: USA

Increasing a number in a custom user field by one every year.

I use ACT Pro 2011 on Windows. I created a custom user field for anniversaries. Every year I need to increase that number by one.  Is there a quicker way then going in file by file, erasing the old number and typing the new number?

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Increasing a number in a custom user field by one every year.

New Member
Posts: 6
Country: USA

Re: Increasing a number in a custom user field by one every year.

I send them a mail mereged letter congratulating them on their state bar anniversary with that number inserted into the document.  Every year that number is one year larger.

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Increasing a number in a custom user field by one every year.

What I'd suggest is that you use a date field and then a second field that calculates the number of years since the date...
You can use this add-on to do the calculations: http://exponenciel.com/actaddons/actaddon.aspx?ID=111&ResID=Aff_glc0742
Administrator
Posts: 314
Country: United_Kingdom

Re: Increasing a number in a custom user field by one every year.

I'd agree that, for your needs, having one field for a date and another for number of years would work best.

 

Just to add to what Mike said - it's possible to display "Years Since Date" using the calculated fields already present in Act! 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Increasing a number in a custom user field by one every year.

Administrator
Posts: 314
Country: United_Kingdom

Re: Increasing a number in a custom user field by one every year.

Ah, of course. My bad for not reading the initial post thoroughly!
New Member
Posts: 6
Country: USA

Re: Increasing a number in a custom user field by one every year.

Thanks everyone.