DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
Examples
Manual
Reference
Extensions
Plug-ins
Blog
Forums
Discussions
Sign In
Support
FAQs
Download
Purchase
≡
Show site navigation
Sorting dates with only month and year
Sorting dates with only month and year
romsok
Posts: 38
Questions: 0
Answers: 0
January 2010
edited January 2010
in
General
Hi,
I am populating a column with only month and a year because my table displays monthly stats.
What format should the date (month and year) be in if I want the table to sort it correctly?
Replies
allan
Posts: 61,653
Questions: 1
Answers: 10,094
Site admin
January 2010
You'll need to use a custom sorting plug-in, because I don't believe that any browser's Date.parse() will parse just hte month and year. It should be easy to modify one of the ones available form here: http://datatables.net/plug-ins/sorting
Regards,
Allan
romsok
Posts: 38
Questions: 0
Answers: 0
February 2010
Thanks,
I used the examples to implement this comparison function.
Could someone please criticize my code and let me know how it could have been better written?
[code]
jQuery.fn.dataTableExt.oSort['month-year-desc'] = function(x,y)
{
//array of months
var months=["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"];
dateComponents = x.split(",");//parse x on comma
dateComponents[1] = jQuery.trim(dateComponents[1]);
//determine year
var year = dateComponents[1];
//determine month
var month = 0;
for(i=0; i
This discussion has been closed.
Sign In
·
Register
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Sign In
Register
Quick Links
Categories
Recent Discussions
Unanswered
Categories
73K
All Categories
56
Priority support
22.9K
Free community support
976
General
13
Announcements
2.4K
DataTables
2
DataTables 2
1.3K
DataTables 1.10
90
DataTables 1.9
35
DataTables 1.8
9
CloudTables
2K
Editor
2.8K
Extensions
20
AutoFill
300
Buttons
49
ColVis
28
DateTime
67
FixedColumns
49
FixedHeader
31
ColReorder
28
KeyTable
100
Responsive
22
RowReorder
40
Scroller
157
SearchBuilder
189
SearchPanes
101
Select
25
StateRestore
22
TableTools
209
Bug reports
65
Feature requests
97
Plug-ins
11
Blog
64
Web-site
Replies
Regards,
Allan
I used the examples to implement this comparison function.
Could someone please criticize my code and let me know how it could have been better written?
[code]
jQuery.fn.dataTableExt.oSort['month-year-desc'] = function(x,y)
{
//array of months
var months=["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"];
dateComponents = x.split(",");//parse x on comma
dateComponents[1] = jQuery.trim(dateComponents[1]);
//determine year
var year = dateComponents[1];
//determine month
var month = 0;
for(i=0; i