Firefox date format and filter

[rgjamkhedkarParticipant]

I have set a custom date format for date columns. But dates are not shown in that format in Firefox. Same dates are shown in correct format in Chrome.
I am using version 3.3 of jqwidgets.
Following is date column config –

{
	datafield: 'timestamp',
	cellsformat: 'MM/dd/yyyy HH:mm:ss',
	exportable: true,
	filterable: true,
	filtertype: 'date',
	width: '15%'
}

And following is the datafields config set in source.

{
	name: 'timestamp',
	type: 'date'
}

In original data dates are in MM-DD-YYYY HH:mm:ss format.
In firefox, I think default date format is used, i.e. MM-DD-YYYY HH:mm:ss.
I cannot understand why it works in chrome and not in firefox.
One more problem is, in firefox, date filters are also not working. Gives following error TypeError: an is null.
Please let me know if any more details are needed.

[Peter StoevKeymaster]

Hi rgjamkhedkar,

Set the format to MM-dd-YYYY HH:mm:ss, i.e

{
	name: 'timestamp',
	type: 'date',
        format: 'MM-dd-YYYY HH:mm:ss'
}

The date filter will not work if your Date parsing has failed.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[rgjamkhedkarParticipant]

Hi Peter,
I tried that but doesn’t work. Dates are still shown in MM-dd-yyyy HH:mm:ss format in firefox. Why is this problem only in firefox?
In chrome dates are shown in specified format i.e. MM/dd/yyyy HH:mm:ss. Filter also works correctly in Chrome.

[rgjamkhedkarParticipant]

Hi,
This is a very critical issue for us. Is there any solution? If this is a problem with our code, can you please give some indications as to what might be wrong so that we can fix it. I have tried using earlier version of library. That doesn’t work.
If there is no solution to the problem, is there any workaround?

[Peter StoevKeymaster]

Hi rgjamkhedkar,

You can prepare and share a sample: http://jsfiddle.net/ which demonstrates your issue. That will allow more people to help you.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts