The problem is that it is not sorting correctly (by date), as this new virtual column needs to be a “text” column to display the day with the date combination.
Is there a solution or workaround to get the desired, or similar result?
Haha, you’re right. I did actually notice that, then started writing a response, then thought about something else and completely forgot about the grouping, then erased what I first wrote to post the above message.
But yah, @eddie61 , with that custom concatenation you’re doing, and with the grouping, I see no way you’ll be able to sort like you want. I always recommend using ISO date format, mainly for this exact reason. That is: yyyy-mm-dd. Feel free to add in your day abbreviations at the end of the ISO-formatted date, though.