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?
Question
Calculate Age with UI only field
+17This topic has been closed for replies.
+10Just thought I’d post the formula to calculate someones current age based on their birth date.
FLOOR((TODAY() - {{BirthDate__c}})/ (365*3600 * 24 * 1000))
+10The 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.
+10Our community doesn’t allow a comment to be official. Only replies. Thus, ah… thanks… became official because Bill’s comment was below it.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.