Question formula

Farah · December 31, 2024, 9:35am

Hello,
give me how I can calculate age, formula with baserow

olgatrykush · December 31, 2024, 10:10am

Hey @Farah, welcome to the Baserow community

You can calculate age by using this formula:

Farah · December 31, 2024, 11:25am

I used this formula, but I encountered this error.
date_diff(‘yy’,field(‘Date de Naissance’),today()
Error with formula: argument number 2 given to operator - was of type text but the only usable type for this argument is number.

olgatrykush · December 31, 2024, 11:26am

Hi @Farah, is the ‘Date de Naissance’ field set as a Number field type?

Farah · December 31, 2024, 1:09pm

The type of “date de naissance” is date.

olgatrykush · December 31, 2024, 1:15pm

I apologize—we need a Date field type here not a Number field type, and in the example above, we also have a date field type for the Date of birth field. So, the following formula should work in this case.

olgatrykush · December 31, 2024, 1:18pm

Try this: date_diff(‘yy’,field(‘Date de Naissance’),today())