Help

DATEADD and/or DATETIME_FORMAT not able to be formatted as a date

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1220 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Brent_Cook
6 - Interface Innovator
6 - Interface Innovator

Noob, sorry in advance. (also used to excel which I’m sure makes it even worse)

I created a column that takes a uniform date column (start date) and count column. Then a third column that has the following formula - DATETIME_FORMAT(DATEADD({Start Date},Count-1,‘DAYS’),‘MM/DD/YYYY’). It works well. BUT (there’s always a but) I’m not able to format it as a date, preventing me form being able to but it in a calendar.

My question is: is this antiquated thinking? Did I do something backwards? Or is it a limitation of Airtable that likely is saving me from a bigger problem? And, would anyone have a fix or better solution than the one I laid out?

Thanks in advance for any help you can provide.

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

The DATETIME_FORMAT function converts your date object into a text string. In order to use the date in a calendar you need the date object, not the text string. So, remove the DATETIME_FORMAT part of your formula.

DATEADD({Start Date}, Count-1, 'DAYS')

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

The DATETIME_FORMAT function converts your date object into a text string. In order to use the date in a calendar you need the date object, not the text string. So, remove the DATETIME_FORMAT part of your formula.

DATEADD({Start Date}, Count-1, 'DAYS')
Brent_Cook
6 - Interface Innovator
6 - Interface Innovator

Works perfectly! Thank you.