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....
So I ran a database maintenance and repair on both parent and subscriber databases - no improvement.
Then I decided to remove the calculated field and recreate it - that worked.... but why was it necessary?