I’m trying to calculate age based on today minus date of birth in a UI only field but I’m not having luck getting the correct result I do get a result, but it is huge. I have tried assuming graduations of days, hours, minutes, and even seconds, but the number is still way too large. Anyone have ideas of how I would formulate this in UI only?
Page 1 / 1
Javascript calculates dates in milliseconds…
ah… thanks…
Just thought I’d post the formula to calculate someones current age based on their birth date.
FLOOR((TODAY() - {{BirthDate__c}})/ (365*3600 * 24 * 1000))
Thanks for posting this Bill.
Hey guys. We probably don’t want the official response for this question to be “ah… thanks…”
Good catch Matt!
It was a well crafted response
The Officially correct answer to calculate someones current age based on their birth date is:
FLOOR((TODAY() - {{BirthDate__c}})/ (365*3600 * 24 * 1000))
I take full credit. I would never think to say it is Bill McCullough who is the Skuid Wizard. I am the Walrus. Coo Coo CaChoo.
Our community doesn’t allow a comment to be official. Only replies. Thus, ah… thanks… became official because Bill’s comment was below it.
View our Community Site Map
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.