Calculating months from a date in mirror column to today's date, updated daily

Platform discussions
, , , ,
1

I’m looking for a way to calculate the age (months to one decimal place) of an item in our inventory, based on a manufacture date that appears in a mirror column. I need the age to be dynamic, ie: updated on a daily or weekly basis, so that the displayed age is always current.

I have tried with various automations, formulas and third-party app (General Caster) but haven’t had any success having the age remain dynamic and update daily.

Any suggestions would be most welcome.

2

Hi @Shazzle ,

I would be happy to assist you with this.

But before I do, can you list the formulas or automations you’ve tried so far. Perhaps I could help debug it or help you find a workaround.

Best regards.

3

Hello,
You can achieve this by using a scripting language like JavaScript or Python to calculate the age based on the manufacture date. Schedule a daily or weekly script execution to keep the age updated dynamically.
floridablue.com