I’m trying to create a way to group entries by year and month in descending order.
I created a virtual column to extrapolate the year and month from the date and time stamp for each entry.
First the result shows up as 20175, 20176 etc, which is visually unappealing. I’d like to be able to convert this to something like 2017-5 or 5-2107 or better yet May 2017. Is there a way to do that?
Secondly when I group these entries by the Year Month column in descending order, I get an unexpected result.
I’ve tried displaying two different ways 1. month first/year last 2. year first/month last. Neither way gives me a chronologically accurate list.