Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Calculated date not an option for Gantt Chart

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
454 2
cancel
Showing results for 
Search instead for 
Did you mean: 
superdave10
4 - Data Explorer
4 - Data Explorer

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.

 
DATETIME_FORMAT(DATEADD({Calculated End date},{Days Needed to Complete},'days'),'MM/DD/YY')
 
The dates are calculating just fine, but when I try to add a Gantt view, it doesn't allow me to choose these fields to determine the dates for the Gantt.  What do I need to do to have Airtable recognize the output of this formula as a date?
1 Solution

Accepted Solutions
djseeds
5 - Automation Enthusiast
5 - Automation Enthusiast

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

See Solution in Thread

2 Replies 2
djseeds
5 - Automation Enthusiast
5 - Automation Enthusiast

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

superdave10
4 - Data Explorer
4 - Data Explorer

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.