Weekdays sort - BO day sort doesn't work

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:

Wednesday
Friday
Monday
Saturday
Sunday
Thursday
Tuesday

I don’t know what sort BO is using but it is not weekday. Also not alphanumerical for that matter. Is there a list where these sorts are specified?

hans


hans kingma
unisource carrier services
industriestrasse 21
8403 wallisellen
switzerland
phone: +41 1 839 32 65
fax: +41 1 877 4490


Listserv Archives (BOB member since 2002-06-25)

Hans,

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

That’s it. Thanks!

-rm


Listserv Archives (BOB member since 2002-06-25)

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.

good luck,
mirko.


Listserv Archives (BOB member since 2002-06-25)