Formula to calculate age from a birthday date

New to nocodb here and still not familiar with the formula syntax, I can’t figure out a way to make it work.
So far I have this:

DATETIME_DIFF(NOW(), {BIRTHDAY_COL}, "y")

thank you for any guidance :slight_smile:

This should work if BIRTHDAY_COL is a Date type.
When you edit the formula, does it show any errors?

Learn more about Date formulas: Formulas - NocoDB