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?
Different date format dd,mm,yyyy to calculate age
+3
+29The 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?
Can you show some specific examples where Airtable is producing the incorrect results?
+3The 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?
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.