Skip to main content

Sorting by chronological order

  • March 14, 2022
  • 1 reply
  • 20 views
T

I have a formula that groups together transactions within each month.
Formula is:
DATETIME_FORMAT({Pickup Date}, ‘MMMM’)

I need to sort the months in chronological order instead of alphabetical. Is there a concatenation or formula that will return this result?

1 reply

Mohamed_Swella1
Forum|alt.badge.img+17

Hi @Tiffany_Oney ,

You can use MM instead of MMMM to get the month number (even if another field) then use it to sort?

    Terms & ConditionsAccessibility statement