Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Different date format dd,mm,yyyy to calculate age

Topic Labels: Formulas
1809 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Chala_Chase
4 - Data Explorer
4 - Data Explorer

Hi i am in New Zealand and our date format is dd,mm,yyyy and I am trying to calculate years and months using this code: DATETIME_DIFF(TODAY(), {Date Of Birth}, ‘years’) & ’ years, ’ & MOD(DATETIME_DIFF(TODAY(), {Date Of Birth}, ‘months’), 12) & ’ months’. It is working however only on this date format (mm,dd,yyyy) how can i change this so it works for me please?

2 Replies 2

The format for displaying dates should not affect the date calculations, as Airtable internally stores all dates in ISO 8601 format.

What is the field type for {Date Of Birth}?
If it is a Date field, what is the date format?
image

Can you show some specific examples where Airtable is producing the incorrect results?

Oh great I have changed the Date format thank you so much that worked