Sorting by year...parameter?

I’ve got the same problem but the ampersand is there...

I’ve created a bunch of docs (0 menu index for each) with the date published at the beginning of the title, using this format: 01.01.2010. ("02.02.2010 • Here is an article" )

I’d like them to be displayed newest first, but the one doc from 2009 is sorted according to the month (12.12.2009), when I’d like it at the bottom since it’s the oldest.

Here is Ditto call: [[Ditto? &depth=`2` &parents=`146` &hideFolders=`1` &tpl=`accordion` &paginate=`0` &orderBy=`longtitle DESC`]]

All docs are titled (longtitle) with date first, in month.day.year format (ex: 07.07.2010)

Thanks very much to wiser eyes than mine for a solution!

If you want to sort by date, why don’t you use the format yyyy-mm-dd (which is recommended by the International Standard ISO 8601, http://www.cl.cam.ac.uk/~mgk25/iso-time.html, for just that reason)?
You could use the format yyyy-mm-dd in the title, and your format mm.dd.yyyy in the longtitle - so you could sort by title and display the longtitle for the convenience of the readers.

Thank you! That makes good sense, of course.

However, having followed that suggestion, I am still coming up with one date out of order. Sorting according to title DESC, all goes fine until 2010.07.07, which ends up at the bottom, following 2009.12.12, which follows 2010.02.15, which follows 2010.03.15

display =

03.15.2010
02.15.2010
12.12.2009
07.07.2010

I’ve checked for spaces, and there are none. Any suggestions?

The ordering parameters for Ditto are &sortBy and &sortDir (not &orderBy ) - that may cause the wrong output.
Sorry, my error. See the following posts.

Thanks! Unfortunately, still incorrect order for 07.07.2010, all others correct.

Current call is: [[Ditto? &depth=`2` &parents=`146` &hideFolders=`1` &tpl=`accordion` &paginate=`0` &sortBy=`title` &orderBy=`ASC`]]

(also tried &orderBy=`DESC`, same results but inverse)

See http://www.pogwatch.com/ditto/ditto-sort.html

Ditto wants a UNIX timestamp. Why not use &orderBy=`pub_date ASC,longtitle ASC`

http://ditto.modxcms.com seems to have issues at the moment.

"representing the number of seconds that have passed since 1st January 1970" Wow!!! (that could make me feel very old....)

Thanks for info, and for the link, mrhaw! That explains tons of stuff, even things I didn’t think to use.

Much appreciated

@mrhaw:
Thank you too for the link http://www.pogwatch.com/ditto/ditto-sort.html - so I see my remark above was wrong. I referred to the old documentation of Ditto 2.0.1; sorry for the irritation...

Hey! I have done the same thing, you had a good intention!! Rock on!