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

Sorting week days

I have created a listbox with the weekdays. However they are lined in the wrong order. How can I correct this? I tried the sort by expresion option but couldn't succeed to sort them in the correct order. Thanks

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

how are you creating your weekdays?

maybe use Sort by Expression

     =Match(WEEKDAYFIELD,'Mon','Tue','Wed','Thu','Fri','Sat','Sun')

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

10 Replies
tresesco
MVP
MVP

Could you post a sample/screenshot?

vinieme12
Champion III
Champion III

how are you creating your weekdays?

maybe use Sort by Expression

     =Match(WEEKDAYFIELD,'Mon','Tue','Wed','Thu','Fri','Sat','Sun')

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sergio0592
Specialist III
Specialist III

Try with Properties/Sort/Sort by expression

and as expression : index('mon  thue  wed  thur   frid  sat  sun', WeekDayField)

Anonymous
Not applicable
Author

maybe this (sorts correct in my app)

only({1}weekday(yourdatefield))

its_anandrjs

Better if you add one inline table in your data model and connect the Weekdays field with your Weekdays field in data model this will effective worked here.

WeeDaysSort:

Load * Inline

[

WeekDays,SortOrder

Mon,1

Tue,2

Wed,3

Thu,4

Fri,5

Sat,6

Sun,7

];


Regards

Anand

shraddha_23
Partner - Creator
Partner - Creator

Hi

find attached screenshot

use this expression:- Match(WeekDay,'Mon','Tue','Wed','Thu','Fri','Sat','Sun') in sort tab


Task.JPG

its_anandrjs

If you required this in the front end UI then better you can do this way on your chart sort properties.

Ex:-

=ONLY( Match( YourWeekDayFieldname,'Mon','Tue','Wed','Thu','Fri','Sat','Sun' ) )


Anonymous
Not applicable
Author

thank you very much

dezmundw15
Contributor III
Contributor III

I was having an issue sorting my date and the formula you provided worked!

Thanks,

Desmond