Solved: Sort dates that are in a text column - Page 2

eddie61 · 07-05-2022 12:41 PM

Hi all

I like to display dates to my users in the following way (and the code that I use in the virtual column):

CONCATENATE(
  INDEX(
   LIST(
    "So", "Mo", "Di", "Mi", "Do", "Fr", "Sa"
   ),
  WEEKDAY([datum])
 ),
 ", ",TEXT([datum],"dd.mm.yyyy")
)

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?

Thanks in advance.

Adrian

Marc_Dillon

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.

View solution in original post