It would be geat to have a native feature that will calculate the age for contacts rather than the workaround via workflow by creating a custom property "today's date".
PLEASE make this a native function in HubSpot or give clear examples of workflows to make it happen. Age is extremely necessary for our business.
It would be great to have a DOB field native. Then from there let the display types be the various things people want.
it's possible to use a workflow and a calculated property to approximate their age, but even that doesn't quite work, as calculated properties round to the nearest number, so if a contact is e.g. 23 years and 8 months old, it will round up to 24 years old.
After some work, here's the best solution/workaround I've been able to come up with.
To get a calculated age:
This setup mostly works, with one exception -- calculated properties will round times to the nearest year when displaying the value in a contact view. so if someone is e.g. 31 years old and 6+ months, then they will be rounded up to 32 years old. A workaround to get a more accurate age:
why 31,536,000,000? because the time between property ("internal - calculated age (rounded)") is stored in 1000ths of a second. so 1000 * 60 seconds * 60 minutes * 24 hours * 365 days = 31,536,000,000.
Afterward, your new "Calculated Age" property will display age with several decimal points. e.g. 22.7893.
Hope this helps others. I'd much prefer a built in field, but this will do for now. haha.
This is really imprtant for us too!
@Arden Thank you for your very helpful answer!
>1000 * 60 seconds * 60 minutes * 24 hours * 365 days = 31,536,000,000.
This is not considered about a leap years.
I believe the formula below is better
1000 * 60 seconds * 60 minutes * 24 hours * 365.25 days = 31,557,600,000
I'm really surprised this isn't a feature yet. This is definitely needed.
@Arden would it be unreasonable for me to request that you make a video of your above answer? Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.