I wanted to data as month and year. I followed these instuctionsin an old post:
Add a Year Column: FieldYear = YEAR(Date)
Add MonthColumn: FieldMonth = MONTH(Date)
THEN ADD SORTORDER column using the two extra columns created above and in this order : SortOrder = CONCATENATE(FieldYear,FieldMonth)
(found that solution here : Link)
That kind of works with ONE exception (see image )
You can see where the month has is January ( represented by a 1 ) it is in the wrong month order.
The answe ( I think ) is to format the month number as 01 rather than 1.
Any idea How do you do this? Or is the more efficent way to do the entire thing?
Solved! Go to Solution.