I am sorting a service schedule by date from a view based on a slice. If I use [Date] to sort it yields for instance โ9/10/19โ however I would like to have the day for instance โTuesdayโ as part of the view so I created a virtual column and used the formula below to get โTuesday September, 10โ for example. I thought the problem was solved.
However when sorting the view, the system is not sorting ascending or descending based on the whole date. It is sorting based on the date of the week. SEE SCREEN SHOT. So if the results include two (2) Tuesdays they are next to each other regardless of if one is Tuesday the 1st and the other is Tuesday the 12th. What would be the expression correction to fix this?
Concatenate(Switch(Weekday([Today]),1,"Sunday ",2,"Monday ",3,"Tuesday ",4,"Wednesday ",5,"Thursday ",6,"Friday ",โSaturday โ),Switch(MONTH([Today]), 1, โJanuaryโ, 2, โFebruaryโ, 3, โMarchโ, 4, โAprilโ, 5, โMayโ, 6, โJuneโ, 7, โJulyโ, 8, โAugustโ, 9, โSeptemberโ, 10, โOctoberโ, 11, โNovemberโ, โDecemberโ),โ, โ,Day([Today]))
When you use the โGroup Byโ functionality, Iโm afraid there is no solution with your date syntax. Your calculated value is a text string and it sets the order because of the first letter, then the next one etc.
Understood. Thank you.
Youโre welcome
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |