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

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
    ------------------------------