
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 11, 2020 02:21 PM
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 11, 2020 03:59 PM
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 11, 2020 04:30 PM
Oh great I have changed the Date format thank you so much that worked
