Item6369 < Bugs

AppliesTo:	Component:	Priority:	CurrentState:	WaitingFor:	TargetRelease	ReleasedIn
Engine		Normal	No Action Required		n/a

If I have the following table

%TABLE{sort="on"}%
| *label* | *date* |
| docs | 08/29/2009 |
| docs | 12/08/2009 |
| docs | 01/28/2009 |
| docs | 01/27/2009 |

an ascending sort should show

| docs | 01/27/2009 |
| docs | 01/28/2009 |
| docs | 08/29/2009 |
| docs | 12/08/2009 |

It does not. Instead 01/28/2009 comes before 01/27/2009

ascending: screenshot (incorrect sort):

descending: screenshot. sort order as expected:

-- TWiki:Main/VickiBrown - 08 Dec 2009

Thanks Vicki - this is an issue.

In the above example-its string sorting, and it has issue. I verified on trunk repository code, its an issue.

-- TWiki:Main/SopanShewale - 04 Jan 2010

Date format 12/08/2009 is not supported because it is undefined. It is 8 Dec 2009 in USA and 12 Aug in many other places around the world. Please use ISO dates or any other date documented in TimeSpecifications.

Setting this to no action required.

-- TWiki:Main.PeterThoeny - 04 May 2010

ItemTemplate
Summary	TABLE ascending sort puts 8 before 7
ReportedBy	TWiki:Main.VickiBrown
Codebase
SVN Range	TWiki-5.0.0, Sun, 27 Sep 2009, build 18153
AppliesTo	Engine
Component
Priority	Normal
CurrentState	No Action Required
WaitingFor
Checkins
TargetRelease	n/a
ReleasedIn

Attachments

Topic attachments
I	Attachment	History	Action	Size	Date	Who	Comment
png	Item6369-ascending.png	r1	manage	11.9 K	2009-12-08 - 21:50	UnknownUser	ascending: screenshot (incorrect sort)
png	Item6369-descending.png	r1	manage	11.5 K	2009-12-08 - 21:50	UnknownUser	descending: screenshot. sort order as expected

Item6369: TABLE ascending sort puts 8 before 7

Item Form Data

Edit Form Data

Detail