Skip to main content
Solved

Formula to display someone's age based on date?

  • July 31, 2023
  • 0 replies
  • 324 views
Forum|alt.badge.img+3

Hello I wanted to see if there was a way to calculate someone's age based on the day that they enrolled with us. I have the DOB as a date field and the Start date as well.  It would be easy to just do [DOB]- [Start Date] and get the days but I would like the answer to be displayed in years if the person is older than 1 year old and displayed in months if they are less than a year old on a Formula-Text field. Majority of Clients are Children but we also have mothers join programs. Would this be possible or is manually the only way?

Thank you in advance, I appreciate your help. 



------------------------------
Maritza Acosta Gonzalez
------------------------------

Best answer by MikeTamoush

This makes small assumptions like a month is 30 days, and a year is 365, so will be smalll decimals off, but try this:

var number AgeInDays = ToDays([DOB]-[Start Date]);
var number AgeInMonths = Round(ToDays([DOB]-[Start Date]) / 30, 0.01);
var number AgeInYears = Round(ToDays([DOB]-[Start Date]) / 365, 0.01);

If(
 $AgeInDays<=30, ToText($AgeInDays) & " days.",
 $AgeInDays>=365,  ToText($AgeInYears) & " years.",
 ToText($AgeinMonths) & "Months."
 )



------------------------------
Mike Tamoush
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+20
    • MikeTamoush
    • Registered
    • Answer
    • July 31, 2023

    This makes small assumptions like a month is 30 days, and a year is 365, so will be smalll decimals off, but try this:

    var number AgeInDays = ToDays([DOB]-[Start Date]);
    var number AgeInMonths = Round(ToDays([DOB]-[Start Date]) / 30, 0.01);
    var number AgeInYears = Round(ToDays([DOB]-[Start Date]) / 365, 0.01);

    If(
     $AgeInDays<=30, ToText($AgeInDays) & " days.",
     $AgeInDays>=365,  ToText($AgeInYears) & " years.",
     ToText($AgeinMonths) & "Months."
     )



    ------------------------------
    Mike Tamoush
    ------------------------------
      Terms & ConditionsAccessibility statement