# how do you calculate the age (in months) using the date of birthday?

Options
Member

how do you calculate the age (in months) using the date of birthday?

Can I use this:

ROUND(DATEDIFF(`INFANT'S DETAILS:\nDate of Birth`,CURRENT_DATE()) / 365,1)*12

• Coach
Options

This is what I would use:

ROUND(DATEDIFF(CURRENT_DATE(),`INFANT'S DETAILS:\nDate of Birth`)/ 30.437)

Note that I've also swapped the order of Infants details and Current date in the DATEDIFF() function to avoid a negative number.

• Coach
Options

Another approach would be to use the PERIOD_DIFF function, something like:

```period_diff(date_format(CURRENT_DATE(), '%Y%m'),date_format(`INFANT'S DETAILS:\nDate of Birth`, '%Y%m'))
```

I'd advise you to try both, put them side by side and then compare a few examples to what your expected number would be, so you can get the one that works closer to how you'd manually do so.

• Coach
Options

This is what I would use:

ROUND(DATEDIFF(CURRENT_DATE(),`INFANT'S DETAILS:\nDate of Birth`)/ 30.437)

Note that I've also swapped the order of Infants details and Current date in the DATEDIFF() function to avoid a negative number.

```period_diff(date_format(CURRENT_DATE(), '%Y%m'),date_format(`INFANT'S DETAILS:\nDate of Birth`, '%Y%m'))