denghp / jquery-datatables-column-filter

Automatically exported from code.google.com/p/jquery-datatables-column-filter
0 stars 0 forks source link

Date Range date format problem/solution #160

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Have table with dates in "European" format: "dd/mm/yy"
2. Filtering works using "mm/dd/yy" format and confuses months with days 
resulting in wrong filtering.

What is the expected output? What do you see instead?
I expect "01/02/2014" to be later than "02/01/2014" and i see otherwise.

What version of the product are you using? On what operating system?
1.5.6. 

Please provide any additional information below.
I managed to fix that by setting proper dateformat for both 
"datepicker().datepicker()" and "datepicker.parseDate()" in 
fnCreateDateRangeInput(oTable) function. I recommend to place another variable 
here to be set upon plugin lauch like "sRangeFormat", wich will allow user to 
use custom data-formats.

Original issue reported on code.google.com by tomek.wa...@gmail.com on 8 May 2014 at 1:35