Hi Christian, thanks for the follow up, I implemented the script as you described and it's still not sorting correctly:
http://jayfallon.net/tablesorter/tablesorter.html On Dec 19, 1:21 pm, "Christian Bach" <[EMAIL PROTECTED]> wrote: > Hi Jay, > > This will solve your problem: > > // add parser through the tablesorter addParser method > $.tablesorter.addParser({ > // set a unique id > id: 'dates', > is: function(s) { > // return false so this parser is not auto detected > return false; > }, > format: function(s) { > // split > var a = s.split('-'); > // get month num > a[1] = this.getMonth(a[1]); > // glue and return a new date > return new Date(a.join("/")).getTime(); > }, > getMonth: function(s) { > var m = > ['jan','feb','mar','apr','may','jun','jul','aug','sep','oct','nov','dec'] > var l = m.length; > for(var i=0; i < l; i++) { > if(m[i] == s.toLowerCase()) { > return (i+1); > } > } > }, > // set type, either numeric or text > type: 'numeric' > > }); > > /christian > > 2007/12/18, Jay Fallon <[EMAIL PROTECTED]>: > > > > > It's easy to write a parser to convert the months to a sortable value, > > but the days and years are trickier. the current code is as follows: > > > // add parser through the tablesorter addParser method > > $.tablesorter.addParser({ > > // set a unique id > > id: 'dates', > > is: function(s) { > > // return false so this parser is not auto > > detected > > return false; > > }, > > format: function(s) { > > // format your data for normalization > > return s.toLowerCase > > ().replace(/dec/,12).replace(/nov/, > > 11).replace(/oct/,10).replace(/sep/,09).replace(/aug/,08).replace(/ > > jul/,07).replace(/jun/,06).replace(/may/,05).replace(/apr/, > > 04).replace(/mar/,03).replace(/feb/,02).replace(/jan/,01); > > }, > > // set type, either numeric or text > > type: 'numeric' > > }); > > > $(function() { > > $.tablesorter.defaults.widgets = ['zebra']; > > $("#announcements").tablesorter({ > > headers: { > > 0: {sorter:'dates'},1: > > {sorter:false},2: {sorter:false},3: > > {sorter:false} > > } > > }); > > }); > > > On Dec 18, 2:06 pm, Jay Fallon <[EMAIL PROTECTED]> wrote: > > > I need to sort a table based on the date format: 10-Dec-2007. Does > > > anyone know if this is possible with Tablesorter? > > > > I've tried us, uk & iso to no avail. > > > > Thanks, Jay
