Skip to main content

Sort Month name field chronologically instead of alphabetically

  • September 22, 2021
  • 3 replies
  • 148 views
S
Forum|alt.badge.img+1

Hello Airtable community

I have a formula field which show date as month name only: DATETIME_FORMAT({DELIVERY DATE}, “MMMM”) I wanted to use this field to group each month’s records.
Unfortunately, the sort function does not sort chronologically as it should for a date, but rather alphabetically. How can I force a chronological sort?

Thanks in advance
Sally

      3 replies

      A
      Forum|alt.badge.img+18
      • augmented
      • Inspiring
      • September 22, 2021

      Hi Sally. The only way I know how would be like this…

      DATETIME_FORMAT({DELIVERY DATE},'MM') & '-' & DATETIME_FORMAT({DELIVERY DATE},'MMMM')

      It appends the 2 digit month to the front in order to sort the way you want.

        S
        Forum|alt.badge.img+1
        • Sally_de_Witt
        • Author
        • Participating Frequently
        • September 22, 2021

        Hi Sally. The only way I know how would be like this…

        DATETIME_FORMAT({DELIVERY DATE},'MM') & '-' & DATETIME_FORMAT({DELIVERY DATE},'MMMM')

        It appends the 2 digit month to the front in order to sort the way you want.


        Thank you so much! This will work fine for my purposes!

          D
          Forum|alt.badge.img+4
          • Darcie_Tanner1
          • Participating Frequently
          • February 20, 2023

          Hi Sally. The only way I know how would be like this…

          DATETIME_FORMAT({DELIVERY DATE},'MM') & '-' & DATETIME_FORMAT({DELIVERY DATE},'MMMM')

          It appends the 2 digit month to the front in order to sort the way you want.


          This has helped me massively - thank you!

          Terms & ConditionsAccessibility statement