Daterange picker with datatables, filter date column

Question

It is working fine within itself but i want to incorporate this within datatables plugin to filter the records by a single date or a range.

I have a date column in datatables which is in the same dateformat as daterangepicker (each record only has a single date).

Does anybody have any ideas of integrating this? Any help/advice would be fantastic, thanks in advance.

Your question should contain relevant code. I found this looking for a solution, but your link is now broken, so this question is very difficult to use. — random_user_name
– random_user_name, Commented Feb 28, 2015 at 16:50

Community · Accepted Answer · 2017-05-23 12:16:58Z

5

Just answered your other version of this question. To summarize:

Create datepicker inputs.
Copy the date range filter extension from the filters API page.
Give your datepicker inputs the appropriate IDs based on what's in the extension code (or change the extension code to match your datepicker input IDs): fini and ffin are what the extension uses.
In the extension code, specify the zero-based date column(s) that you're using to filter, with iStartDateCol and iEndDateCol.
Bind the table redraw to some event (redraw: oTable.fnDraw();). The example they provide on the API page is a keyup event for the input boxes but it could be a button.

Now whenever the event occurs, the table will redraw taking into consideration the specified date range filtering on the column of choice.

CommunityBot

11 silver badge

answered Mar 19, 2012 at 17:41

mbeasley

4,8745 gold badges32 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1