Community
Showing results for 
Search instead for 
Do you mean 
Reply

Calculated Age field quit working.....

Copper Contributor
Posts: 133
Country: Canada

Calculated Age field quit working.....

Act! Premium Version 16.1.207.0

 

The calculated age field has been working since we upgraded to v16 many months ago.

 

  • First I noticed the calculated date field results were often off by one year. I would change the date by one day, save the record and then change it back - save the record - and the calculated field would reflect the proper age. |

  • Then I started to get odd changes to the date field that contains the data. I enter a date and then ACT inserts another random date upon leaving the field... wierd - it doesn't happen all the time - just periodically.

  • Now the age field is no longer working. 

  • Absolutely nothing has changed to my knowledge.... 

 

  1. So I ran a database maintenance and repair on both parent and subscriber databases - no improvement. 
  2. Then I decided to remove the calculated field and recreate it - that worked.... but why was it necessary?
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Calculated Age field quit working.....

You might check the system clocks of all the systems with Act! ... and, if syncing to mobiles/tablets, those as well
Copper Super Contributor
Posts: 478
Country: Australia

Re: Calculated Age field quit working.....

I noticed this happens when the hotfixes are installed


Jason Dawson Financial Planning
Brisbane | Australia - JDFP Home Page

Act Ver - Act! Premium Version 17.1.169.0, Hot Fix 3
OS - Windows 7 (stand alone machine)
MS Office - Enterprise 2007
Phone - Samsung Galaxy s6