Jan 01, 2021 12:01 PM
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.
Solved! Go to Solution.
Jan 01, 2021 06:27 PM
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')
Jan 01, 2021 06:27 PM
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')
Jan 01, 2021 07:15 PM
Works perfectly! Thank you.