Hey community,
I am decently new to Airtable and am excited to get to know it better, but I am stumped on creating this formula. I’ve beeI have been trying to output the range of a number of days within a week when given the first day of that specific week.
I need it to be formatted with the month like, “June 21-27” in it’s column.
What I have is…
DATETIME_FORMAT({Start Date}, ‘MMMM DD’) & “-” & DATETIME_FORMAT((DATEADD({Start Date}, 6, ‘days’), ‘DD’)
I keep getting error messages like:
Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.
I’ve been messing around with it quite a bit, but can’t seem to produce what I want. I am sure there is a solution to this simple formatting problem. Is there a way to do this using the “Date” field type? Or maybe I can only use DATE_FORMAT() once per line.
