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?
Page 1 / 1
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?
Can you show some specific examples where Airtable is producing the incorrect results?
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?
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.