Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.