Date filter issue

[joyce973Participant]

Hi all,
I have a grid with a date filter on a column. I set up everything and it seems to work:

datafields: [
…
{ name: ‘dc_data’, type: ‘date’, format: ‘dd-mm-yyyy’ },
…
]

and:

columns: [
…
{ text: ‘Data’, datafield: ‘dc_data’, columntype: ‘date’, filtertype: ‘date’, cellsformat: ‘dd-mm-yyyy’, filterable: true, minwidth: 180, cellsrenderer: cellsrenderer},
…
]

Now the problem is when the user tries to select a date range from the column filter (calendar), e.g.: 15/01/2014 – 17/01/2014, it shows the two dates inside the filter box as follows:

15-00-2014 – 17-59-2014

can anybody help me to solve this issue?
thanks
Antonio

[NadezhdaParticipant]

Hello Antonio,

You have incorrect date format. Small letters “mm” are used for minutes, for months you should use capital letters (“MM”):

datafields: [
...
{ name: 'dc_data', type: 'date', format: 'dd-MM-yyyy' },
...
]

and

columns: [
...
{ text: 'Data', datafield: 'dc_data', columntype: 'date', filtertype: 'date', cellsformat: 'dd-MM-yyyy', filterable: true, minwidth: 180, cellsrenderer: cellsrenderer},
...
]

Best Regards,
Nadezhda

jQWidgets team
http://www.jqwidgets.com/

[joyce973Participant]

Thank you, but I tried to change dd-mm-yyyy into dd-MM-yyyy but nothing happened. I still have the problem.

[joyce973Participant]

Moreover, if that can help, the browser console shows the following error message:
“Uncaught TypeError: Cannot read property ‘toString’ of null amorelli.simply-winspace.it/jq/jqxdata.js:7”

this is strange, isn’t it?
A

[NadezhdaParticipant]

Hi Antonio,

Could you, please, provide us with some sample data so that we may determine the source of the issue?

Best Regards,
Nadezhda

jQWidgets team
http://www.jqwidgets.com/

[joyce973Participant]

I solved that. Sorry, but I uploaded the wrong file on my server. 🙂
Now it works properly, thank you!

[Author]

Posts