|
|
|
RightNow Customer Forum :
Solution Discussion :
Reporting & Analysis :
Sorting by Date.
|
|
|
|
|
|
|
|
|
Sorting by Date.
|
|
Avital1!
New Participant
Posts: 1
Message 1 of 2
Viewed 383 times
|
|
|
Hi, I have created a report that is showing the date according to the week start. The date is displayed as: September 27, June 28.... However when I sort the date column the sort is not correct. For example it is showing: August 02
August 09
August 16
August 23
August 30
July 05
July 12
July 19
July 26
June 28
September 06
September 13
September 20
September 27 When it should be: July 05
July 12
July 19
July 26
June 28
August 02
August 09
August 16
August 23
August 30
September 06
September 13
September 20
September 27 Please help me how to fix the sorting. Thank, Avital.
|
Solved!
 Go to Solution
|
|
|
10-11-2009 01:24 AM
|
|
|
|
|
|
|
Re: Sorting by Date.
|
|
anash
Trusted Advisor
Posts: 108
Message 2 of 2
Viewed 372 times
|
|
|
Hi Avital, Welcome to the forum! The date_format function returns a string so the dates will be sorted alphabetically rather than chronologically. Try using the date_group function instead.
Amy Nash
Product Development
|
 Accepted Solution
|
|
|
10-13-2009 09:29 AM
|
|
|
|
|
|
|
|
|
|
|
