SearchBuilder + moment/luxon: not sending date value to server

Benz738

Link to test case: https://codesandbox.io/p/live/bb471f34-844d-4ae4-b2c8-233e0fa4ab1f
Description of problem:

Hello!

This is my first post here, I'm using Datatables since many years.. I describe myself as an affecionate user
Jokes apart, in these years, I wasn't able to find all the features of this library anywhere else, so let me say thank you for this!

Now let's talk about the issue I've encountered:

While upgrading an existing table to use the Editor backend + SearchBuilder, I had to localize the datepicker used by SearchBuilder, and noticed that after importing moment (or luxon), the date selected as filter is not sent in the server request.

You can find the problem reproduced on codesandbox, it's the first time I use such tool for a client+server application... anyway the setup is simple and should work for you as well.

The javascript code is inside pages/script.js.
The response json is a mocked, as it's not important to reproduce the issue.

Steps to reproduce:
1. Open the browser console
2. Set SearchBuilder by selecting the "Start date" field -> Equals -> Select a date
3. Now check the request sent and you will see this:

You can also unload moment.js from the html / js and see that without them, the date is sent correctly:

Let me know if you need further info!

Regards

allan

Hi,

Sorry for the delay in replying here. I've just been looking at this and I haven't actually managed to reproduce it locally. Furthermore the CodeStandbox link is 404 for me (possibly a permissions issue, or possibly deleted?).

Are you able to give me a link that is showing the issue?

Thanks,
Allan

Benz738

Hello,

No problem
I received a 404 as well, probably the generated link expired.. I don't know honestly, it's the first time that I try CodeSandbox.

This is a new link, hopefully it will work: https://codesandbox.io/p/devbox/goofy-flower-jhrh7n

It takes some time to build the environment!