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?
1 Like
system
closed
#3
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.