Automation to calculate and update a Contact field

Ah, then no, I do not think there is an automated solution you can use natively within ActiveCampaign. The suggestion of using something like Zapier to bounce the data out and back into ActiveCampaign suggested above could work, depending on your use case.

Hope you find a way of achieving what you need to do.