ColumnControl - dropdown search datepicker bug

ColumnControl - dropdown search datepicker bug

spownspown Posts: 13Questions: 5Answers: 0

Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem:

https://datatables.net/extensions/columncontrol/examples/searchDates/autoLocale-moment.html

When i copy&paste or manually type date into search everything works fine, for example date 28. 11. 2008

When i pick same date from datepicker, table is empty

Answers

  • hserveirahserveira Posts: 15Questions: 4Answers: 0
    edited February 6

    Try modifying the render function on that column to return raw data on type === 'filter':

        { 
            title: 'Start Date',
            data: 'StartDate',
            type: 'date',
            render: function(data, type, row) {
                if (type === 'filter') {
                    return data;
                }
                return DataTable.render.datetime('DD. MM. YYYY')(data);
            },
        },
    
  • spownspown Posts: 13Questions: 5Answers: 0

    I think this is bug

    https://live.datatables.net/cizetiji/

    • select date from datepicker 11. 2. 2026
    • table is empty
    • press f5 = table is ok (date loaded from state and correctly filtered)

    your solution have one problem, date after usage of datepicker in filter is not in right format DD. MM. YYYY

Sign In or Register to comment.