I hope somebody can help me. I have a product list and each item has a [Replace By] date.
Is there a way of displaying how many years are left in a numerical value? example years left “2” by subtracting current date [9/9/2026] - [Today] = 4
This needs to refresh when the user syncs because it needs to be live.
Im happy for this to be a view,field,bot, or anyway anyone can think of.
Hope that makes sense, I’m new at this sorry