- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 18, 2024 12:52 PM
Brand new to Airtable, so forgive me if this is a dumb question. I've shamelessly stolen a formula to calculate start and end dates based off a T- or T+ from a specific event.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 18, 2024 04:43 PM
Hi @superdave10, welcome to the community!
The DATETIME_FORMAT function formats its input date as a string, so if you use that function Airtable will not recognize the formula field as a date. Please try using only the DATEADD function, which outputs a Date:
DATEADD({Calculated End date},{Days Needed to Complete},'days')
DJ, Lead Developer at BaseQL
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 18, 2024 04:43 PM
Hi @superdave10, welcome to the community!
The DATETIME_FORMAT function formats its input date as a string, so if you use that function Airtable will not recognize the formula field as a date. Please try using only the DATEADD function, which outputs a Date:
DATEADD({Calculated End date},{Days Needed to Complete},'days')
DJ, Lead Developer at BaseQL
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 21, 2024 05:58 AM
This solved it! It allowed for me to set as a "date" in the format tab, which wasn't an option before. Thanks for your help.
