I have a DOB column in my database. Is there a way of picking the machine date & calculating the current age ??
You can write that in SQL ... getting today() and then calculate the difference
This is a helpful starting point, and peternlewis's approach using the TIME function is a solid way to get a quick estimate. The division by 365.25 accounts for leap years reasonably well for most use cases.
The off-by-one issue around birthdays is the main limitation here. If you need exact precision—for legal, medical, or official documentation—the more reliable method is to break it down using the YEAR(), MONTH(), and DAY() functions as peternlewis mentioned. You calculate the year difference first, then subtract one if the current month/day hasn't yet passed the birth month/day.
For anyone who wants to verify their macro output or just needs a quick reference for what the correct age should be, I've found this age site helpful for cross-checking.
The keyboard maestro approach works well for automation, but it's always good to have a way to validate the result, especially when dealing with edge cases like February 29th birthdays or when the calculation spans multiple leap years.