Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Getting a Formula Field to Show Up as a Date Field

Topic Labels: Dates & Timezones
219 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Not sure if this is possible as I just started using Airtable.

I created a formula for contracts based on Start Dates and Contract Term that will give me an Automatic Original End Date. Then I have another Field for Bonus weeks which will give me a “Final End Date”

I am looking for a way to make the Final End Date field a Date/Time instead of a Formula field so that I can sort and group a certain way from a Date. Is this possible?

image

image

3 Replies 3

By using DATETIME_FORMAT() you are explicitly telling Airtable to “take this date and turn it into a string”. All you need is the DATEADD() portion of your formula, use the “Formatting” tab in your field config panel to control the display order of months/days.

Hi @Admin_Department1

As @Kamille_Parks says, just use date add and the format tab - like this:

Screenshot 2022-07-18 at 16.49.28

and

Screenshot 2022-07-18 at 16.50.07

You may also consider modifying the formula to remove the errors if there is no original date:

Screenshot 2022-07-18 at 16.53.40

Hope this helps.

Julian

Thank you all so much!