Filtering a column by date range having date in a particular format.

kunal

Hi,

Thanks Allan for this amazing pluggin. I am trying to filter data based on a column having date in format like Sun, Oct 16 2011. I am doing it from an external popup having datepicker for From date and To date. So basically it will filter data based on the range input by the user and it will only check in one column as against the 2 columns in the example mentioned.

Please give me some idea on how to filter it, I am not able to proceed. Although when I try to sort the column based on the above format it recognizes that the column has date in it and sorts it perfectly as it should be done. Please give me suggestions/links if this has been discussed before.

Thanks.

kunal

I have been able to work through the above issue by going through the forum. Thanks.

Now I have a question again when the dates are filtered based on the user selection, I have to give an external control in the drop down which shows all the data present in the table with the initial sorting applied. I have tried using fnDraw() but it does not redraw the table to its original state. Please give some suggestion on how this can be achieved.

studioleland

@kunal any chance you could post your solution. Very interested in seeing how you got it working.

allan

@studioleland: I've just added a reply to your other post here: http://datatables.net/forums/discussion/313/filter-date-range#Item_7

Allan

kunal

@studioleland: You can refer to this post for having a look at the code.

http://datatables.net/forums/discussion/7209/redrawing-table-after-applying-filtering-by-a-click-on-dropdown#Item_6