0
Sort table by month name in numerical month order?
I have a table grouping data by month. When I leave the column as month(my_date) I get months 1...12 and the table is nicely ordered Ascending from 1 to 12 (my choice).
I've now decided to use monthName(month(my_date)) and the table is no longer sorted by month number, but now by alphabetically by name.
How do I get this table to sort Ascending from January to December?
Thanks!
8 replies
-
You need to add the month number in front of the month names. You can create a new formula field and put this in the code:
format(my_date, "MM - MMMM")
This will put a two digit number in front of the month name. Now you can sort ascending and it will put it in correct order.
You can check out the format() function and the date/time formats for more info.
Content aside
- 1 yr agoLast active
- 8Replies
- 290Views
-
3
Following