1

how to Calculate individual age based on Date of Birth using formula fields when i enter date of birth age must be updated

  • you have to take two fields by using roll-up summary you can calculate. – Sathya Jan 28 '14 at 7:01
2

@Satya.

Create field:Age(Formulae data type).

In the formulae use: year(Today())-year(DOB__C)

| improve this answer | |
1

Yo can use any of the following

IF(MONTH(TODAY())>MONTH(Birthdate),YEAR(TODAY())-YEAR(Birthdate),IF(AND(MONTH(TODAY())=MONTH(Birthdate),DAY(TODAY())>=DAY(Birthdate)),YEAR(TODAY())-YEAR(Birthdate),(YEAR(TODAY())-YEAR(Birthdate))-1))

FLOOR((TODAY() - DateofBirth__c)/365.2425)


TEXT(YEAR(TODAY() ) - YEAR( YOUR_DATE_OF_BIRTH_API ))
| improve this answer | |
  • 1
    How about to add some explanation to your answer? – Sergej Utko Jan 28 '14 at 7:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.