Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 22, 2024 05:26 AM
I've found a formula which is partly working for us, originally it was showing the years and months as negative numbers but I've managed to sort out the years aspect but I can't figure out what needs to change to make the months show correctly.
currently shows the response like this 0 Years, -7 Months
Formula being used is
May 22, 2024 06:21 AM
You just need to switch the order of the parameters in the months part of the formula.
I would also change NOW() to TODAY() - NOW() is known to have a large impact on performance and slow down your base.
Finally, I would wrap the whole thing in an IF() so that you don’t get errors if you don’t have a DOB.
May 23, 2024 05:46 AM
AMAZING _ THANK U so much for this - truly appreciate this!!