Very new to AirTable!
I would like assistance on the following:
I would have made a formula for:
if the single select field ‘major/minor’ is Major NC, then give a date 12 weeks from field ‘report date’, if minor NC, do nothing. and I see the correct results showing in that new column that I made. But I would just like the date to show dd/mm/yyyy but I am getting 2022-07-22T00:00:00.000Z for some reason?
With the way this formula is written, if the Major/Minor field has any value except for ‘Major NC’, it will simply return blank.
For the formatting of the date, we can leverage the DATETIME_FORMAT function, which allows you to specify the desired format using any number of permutations that you can find in this article.
It’s quite comprehensive, and it’s worth diving into it a bit if you’re curious about what’s possible there.
Regarding the calendar view…
I wanted to clarify. Are you trying to only see records on the calendar that reflect records that have a date value return from the formula?