- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 22, 2024 05:12 PM
Hi there: There are two records with to dates, I need to use the DATETIME_DIFF function, but it only works If I have the fields side by side, not in two diferent records. How can I work this out?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 24, 2024 09:32 PM
Hi,
All 'vertical' computing must be done in a table, where these records are linked (in your case, where 'Nomrbe' column linked.)
You should add rollup field and use formula, for example DATETIME_DIFF(MIN(values), MAX(values),'days'). On the record, where primary field value is 'MARIA PRISCILA', and these 2 records are linked to, it will give you a difference between MIN and MAX dates of linked records.
![Sistema_Aotearo Sistema_Aotearo](https://community.airtable.com/legacyfs/online/avatars/3X/d/9/d9d56e9b39ff7c3ba4f7225efe8a0bdca0f2d403.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 22, 2024 06:03 PM
I think a formula isn't what you're looking for. Might be something you can configure in an interface? Not sure how complex your base is, but you could give it a go with the new dashboard interfaces.
Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 22, 2024 06:47 PM
You'll need to link the two records together and use a lookup field to display the date from the linked record I'm afraid
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 24, 2024 09:32 PM
Hi,
All 'vertical' computing must be done in a table, where these records are linked (in your case, where 'Nomrbe' column linked.)
You should add rollup field and use formula, for example DATETIME_DIFF(MIN(values), MAX(values),'days'). On the record, where primary field value is 'MARIA PRISCILA', and these 2 records are linked to, it will give you a difference between MIN and MAX dates of linked records.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 25, 2024 04:43 PM
Thanks
![](/skins/images/75AB00B4920FD2D67A8CABF77C9DECC4/responsive_peak/images/icon_anonymous_message.png)