Hi, Here is that bloke that want’s to sort date’s again. This time I’d like to sort the days of the week. Business objects is not sorting properly. I have a Object which shows the days of the week (in the english language) when I select “Day” from the custom sort field BO sorts like:
If you have a DATE object, you can create a ‘DayofWeek’ for that (to display the Day Name). For Instance:
Create a report from the BEACH universe with Customer Name and Reservation date.
Create a blank column and insert the following variable in it: =DayName()
If you entered this as a Formula, turn it into a variable… click on This Variable (mine is aptly named, DayofWeek) and choose FORMAT\SORTS
Click ADD, then Choose DayofWeek.
Choose CUSTOM from the Sort Definitions… Press the VALUES button.
in the dropdown menu that appears, choose Day
Hi, Here is that bloke that want’s to sort date’s again. This time I’d like to sort the days of the week. Business objects is not sorting properly.
The only way I know of sorting textual dates consists of doing the conversion to text on report level, rather than on universe level. Thus, months & days can be converted to text using alerters – performing a sort on the resulting field will give you a proper sort based on the date values and not on the text-values.