topic Re: Sorting Week& year values in filter pane in App Development

Sorting Week& year values in filter pane

Rushi21 — Fri, 15 Nov 2024 21:35:55 GMT

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.

Re: Sorting Week& year values in filter pane

Or — Mon, 10 Jul 2023 12:44:06 GMT

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.