The second tab works because the calendar view knows to convert the value to a date value for the calendar view and knows how to sort it. In the first tab, a list treats all columns as a character and only knows how to sort as character string (and in some cases, a numeric value). You are attempting to sort essentially a character string. It’s not treated like a date the way calendar view works. In your case, from left to right 1 comes before 9 just like a comes before b. When you sort the list view, it sorts left to right as alphanumeric. To properly sort a date in this way, it needs to be in YYYYMMDD format.