Solved: Sort Month Name - Page 2

App_Creator · 03-21-2019 03:04 AM

Hi!

I would like to find out if there’s any way to sort month name according to month order (Jan, Feb, Mar, Apr, …) instead of alphabetical order (Apr, Feb, Jan, Mar, …)?

Thank you!

LeventK

@App_Creator
If it’s not a big deal for you, slightly change your SWITCH expression:

SWITCH(
MONTH([Date]),
1, “1-Jan”,
2, “2-Feb”,
3, “3-Mar”,
4, “4-Apr”,
5, “5-May”,
6, “6-Jun”,
7, “7-Jul”,
8, “8-Aug”,
9, “9-Sep”,
10, “10-Oct”,
11, “11-Nov”,
“12-Dec”
)

View solution in original post