Skip to main content

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?

Hi @Tiffany_Oney ,


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


Reply