Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Rushi21
Contributor
Contributor

Sorting Week& year values in filter pane

I have created a filter pane for the week&Year field which i created at the backend. I want them to be sorted in front end first by year and then with respect to the Week no.

example:-

W1-2023

w2-2023

W1-2022

W2-2022 and so on.

Screenshot 2023-07-10 175014.png

Labels (1)
1 Reply
Or
MVP
MVP

I would recommend using Weekname(Date) to create your weeks, rather than string-based concatenation. If you do want to use string based, you can either flip the order so it's e.g. 2022-W38, or you can create a custom sort order along the lines of Right(Week,4) & Week to force the year up front.