Unable to find an exact date using FixedColumns component and calendar with data in DateTime format
Unable to find an exact date using FixedColumns component and calendar with data in DateTime format
slolo
Posts: 127Questions: 27Answers: 2
in FixedColumns
Link to test case: https://live.datatables.net/nilaciqu/1/edit
Debugger code (debug.datatables.net): NA
Error messages shown: NA
Description of problem: Hello,
Hello,
I'm having a small problem using the FixedColumns component with dates in ISO 8601 format.
In a test case, searching for a specific date doesn't work.
However, sorting is functional, and I can search for dates before or after. Only the exact date doesn't work.
Just to clarify, my regional settings are in French.
Ex. Sorting on date: OK
Ex. Filtering on a later date: OK
Ex. Filtering on a exact date: KO
However, the date 2025-11-09 does exist in the table.
Just to clarify, I don't use Moment.js or Luxon.
Thanks in advance for your help and have a nice day.
Lolo
Answers
Take a look at this example of how to set ColumnControl to search only the date when both the date and time are supplied. Updated test case:
https://live.datatables.net/nilaciqu/2/edit
Kevin
Hello @kthorngren,
Thanks for your answer.
If I modify your test case with
mask: 'DD/MM/YYYY',instead ofmask: 'MM/DD/YYYY',(for French display), here is what I have:Really strange, isn't it?
See: https://live.datatables.net/nilaciqu/3/edit
maskshould be in ISO8601 format, as noted in the docs.That said, I suspect you are running afoul of a time zone error if you aren't in UTC yourself. I need to find some time to look into that more.
Allan
Hi @allan,
I have just done what @kthorngren told me
However, I can't get my test case to work. Are you using moments.js to make the search work?
And if I try to use "format" in the options, I get the following error message:
For information, here is my regional settings:
