Forum Discussion

JenniferDriscol's avatar
JenniferDriscol
Qrew Member
2 years ago

Formula for figuring out age in months

Hi, I have tried a bunch of different ways but I need to figure out the age of a child in months. is there a formula for this? ------------------------------ Jennifer Driscoll ---------------...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

this beauty will show like

2 yrs 11 months and 5 days 

you can drop the days part and get years and months.



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

Sorry, try this:  substitute your field name for date of birth into the first line.

var date MyDate = [DOB];
 
var number Years = Year(Today())-Year($MyDate) -
 
            If( Month(Today())<Month($MyDate)
 
                or
 
            (Month(Today())=Month($MyDate) and Day(Today())<Day($MyDate)),1,0);
 
 
 
var number Months =  If(
 
            Month(Today()) > Month($MyDate), Month(Today()) - Month($MyDate),
 
            Month(Today()) = Month($MyDate) and Day(Today()) >= Day($MyDate), Month(Today()) - Month($MyDate),
 
            Month(Today()) = Month($MyDate) and Day(Today()) < Day($MyDate), 11,
 
            12-(Month($MyDate) - Month(Today())));
            
$Years * 12 + $Months


------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • JenniferDriscol's avatar
    JenniferDriscol
    Qrew Member
    2 years ago

    Hi,

    I tried Both. The first one said there is a syntax error--parenthesis are mismatched. the 2nd one said that there are extra characters at the end. What in the heck am i doing wrong. I copied and pasted



    ------------------------------
    Jennifer Driscoll
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      2 years ago

      I only posted one formula above.  That whole thing is one formula.   Please use th whole formula and if you have a syntax error, please post a copy and paste of your formula so we can debug it.



      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
  • JenniferDriscol's avatar
    JenniferDriscol
    Qrew Member
    2 years ago

    I got It!  Thank you so much. Can I also get the  year/month/day formula for my older kids?



    ------------------------------
    Jennifer Driscoll
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      2 years ago

      try this

      var date MyDate = [My date];

      var text Years = ToText(Year(Today())-Year($MyDate) -

                  If( Month(Today())<Month($MyDate)

                      or

                  (Month(Today())=Month($MyDate) and Day(Today())<Day($MyDate)),1,0));

      var text Months =  If(

                  Month(Today()) > Month($MyDate), ToText(Month(Today()) - Month($MyDate)),

                  Month(Today()) = Month($MyDate) and Day(Today()) >= Day($MyDate), ToText(Month(Today()) - Month($MyDate)),

                  Month(Today()) = Month($MyDate) and Day(Today()) < Day($MyDate), "11",

                  ToText(12-(Month($MyDate) - Month(Today()))));

      var text DaysDisplay = If ( Day(Today()) > Day($MyDate), ToText( Day(Today()) - Day($MyDate) ),

                              Day(Today()) = Day($MyDate), "0",

                              Day(Today()) < Day($MyDate), ToText( Day($MyDate)-Day(Today())  ));


      var text RawResult=

      $Years & " Year" & If ($Years <> "1","s","") & "<br>" &

      $Months & " Month" & If($Months<>"1","s", "") "<br>" &

      $DaysDisplay & " Day" & If($DaysDisplay<>"1","s", "");

      $RawResult



      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
      • JenniferDriscol's avatar
        JenniferDriscol
        Qrew Member
        2 years ago

        It keeps telling me that a semi colon is needed and the bold expression is highlighted

        var text RawResult=
        $Years & " Year" & If ($Years <> "1","s","") & "<br>" &
        $Months & " Month" & If($Months<>"1","s", "") "<br>" &;
        $DaysDisplay & " Day" & If($DaysDisplay<>"1","s", "");
        $RawResult



        ------------------------------
        Jennifer Driscoll
        ------------------------------