ContributionsMost RecentMost LikesSolutionsRe: Formula for figuring out age in months var date MyDate = [Date of Birth]; 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 ------------------------------ Original Message 8.RE: Formula for figuring out age in months 0Like Jennifer Driscoll Posted 2 hours ago Reply Options Dropdown 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 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 ------------------------------ Original Message 8.RE: Formula for figuring out age in months 0Like Jennifer Driscoll Posted 2 hours ago Reply Options Dropdown 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 ------------------------------ Re: Formula for figuring out age in months 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 ------------------------------ Re: Formula for figuring out age in months I got It! Thank you so much. Can I also get the year/month/day formula for my older kids? ------------------------------ Jennifer Driscoll ------------------------------ Re: Master form to distribute data to many tables? ------------------------------ Jennifer Driscoll ------------------------------ Re: Formula for figuring out age in months 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 ------------------------------ Calculate age of child I have tried several ways but can not find a formula that works to calculate the age of a child ------------------------------ Jennifer Driscoll ------------------------------ 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 ------------------------------