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
How to sort column by date yyyy-mm-dd
How to sort column by date yyyy-mm-dd
mmarini
Posts: 5
Questions: 0
Answers: 0
April 2011
edited April 2011
in
General
Hi all,
I need to sort by date a column in this format:
[code]
Replies
mmarini
Posts: 5
Questions: 0
Answers: 0
April 2011
edited April 2011
Solved, I will show you how :-)
I've called it: "Hidden title date sorting MySQL format (yyyy-mm-dd)"
Just my little contrib to the great page: http://datatables.net/plug-ins/sorting
[code]
jQuery.fn.dataTableExt.oSort['title-date-asc'] = function(a,b) {
var mysqlDatea = a.split('-');
var mysqlDateb = b.split('-');
var x = (mysqlDatea[2] + mysqlDatea[1] + mysqlDatea[0]) * 1;
var y = (mysqlDateb[2] + mysqlDateb[1] + mysqlDateb[0]) * 1;
return ((x < y) ? -1 : ((x > y) ? 1 : 0));
};
jQuery.fn.dataTableExt.oSort['title-date-desc'] = function(a,b) {
var mysqlDatea = a.split('-');
var mysqlDateb = b.split('-');
var x = (mysqlDatea[2] + mysqlDatea[1] + mysqlDatea[0]) * 1;
var y = (mysqlDateb[2] + mysqlDateb[1] + mysqlDateb[0]) * 1;
return ((x < y) ? 1 : ((x > y) ? -1 : 0));
};
[/code]
And in the JS code:
[code]
{ "sSortDataType": "title-date", "sType": "string", "aTargets": [ 0 ] }
[/code]
Regards
crea2k
Posts: 14
Questions: 0
Answers: 0
December 2011
Hi, maybe a stupid question, but where do I put each bit of code ?
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
75.1K
All Categories
57
Priority support
24.6K
Free community support
1K
General
14
Announcements
2.6K
DataTables
129
DataTables 2
1.3K
DataTables 1.10
93
DataTables 1.9
35
DataTables 1.8
9
CloudTables
2.3K
Editor
2.8K
Extensions
20
AutoFill
314
Buttons
34
ColReorder
4
ColumnControl
33
DateTime
68
FixedColumns
51
FixedHeader
31
KeyTable
106
Responsive
24
RowReorder
43
Scroller
168
SearchBuilder
200
SearchPanes
107
Select
27
StateRestore
220
Bug reports
68
Feature requests
101
Plug-ins
11
Blog
73
Web-site
Replies
I've called it: "Hidden title date sorting MySQL format (yyyy-mm-dd)"
Just my little contrib to the great page: http://datatables.net/plug-ins/sorting
[code]
jQuery.fn.dataTableExt.oSort['title-date-asc'] = function(a,b) {
var mysqlDatea = a.split('-');
var mysqlDateb = b.split('-');
var x = (mysqlDatea[2] + mysqlDatea[1] + mysqlDatea[0]) * 1;
var y = (mysqlDateb[2] + mysqlDateb[1] + mysqlDateb[0]) * 1;
return ((x < y) ? -1 : ((x > y) ? 1 : 0));
};
jQuery.fn.dataTableExt.oSort['title-date-desc'] = function(a,b) {
var mysqlDatea = a.split('-');
var mysqlDateb = b.split('-');
var x = (mysqlDatea[2] + mysqlDatea[1] + mysqlDatea[0]) * 1;
var y = (mysqlDateb[2] + mysqlDateb[1] + mysqlDateb[0]) * 1;
return ((x < y) ? 1 : ((x > y) ? -1 : 0));
};
[/code]
And in the JS code:
[code]
{ "sSortDataType": "title-date", "sType": "string", "aTargets": [ 0 ] }
[/code]
Regards