Multiple Sorts with Date

How is your date formatted in your extra column? Only YYYYMMDD is going to work properly. I think it’s Text(%date%, YYYYMMDD) You also need to pad spaces so each column, concated together, has a consistent width.

2 Likes