Skip to main content
Solved

Calculate on date formats

  • February 4, 2021
  • 1 reply
  • 19 views
P

Hello Airtable community ! :grinning:
I am once again asking for your advice.
My problem is that want to remove a month on my date formula which is :
UPPER((DATETIME_FORMAT({Date}), “MMMM”))

So my result looks like this “FEBRUARY” but i want my result to be -1 month so if the date is FEBRUARY, i want it to be JANUARY. I don’t know how to do that can somebody help me ? :thinking:

Best answer by augmented

Replace {Date} with DATEADD({Date},-1,‘month’)

Good luck!

    1 reply

    A
    Forum|alt.badge.img+18
    • augmented
    • Inspiring
    • Answer
    • February 4, 2021

    Replace {Date} with DATEADD({Date},-1,‘month’)

    Good luck!

    P
    Terms & ConditionsAccessibility statement