Date Being Shifted

[swarrenParticipant]

I’m running v3.4.0 and I’m having a problem where I have a date 2012-04-11 and am using the ‘d’ cellsformat option and it shows up as 4/9/2012. Is there a setting I’m missing that’s causing the date to shift?

{text:’Due Date’, datafield: ‘dueDate’, columntype:’datetimeinput’, cellsformat: ‘d’},

[Peter StoevKeymaster]

Hi swarren,

Most probably you don’t load your data correctly into the Grid. I would suggest you to check the initialization of your data source and especially whether you set or not the type: ‘date’ of your date field and its “format” setting if necessary. Then you can also check all the samples with Date columns.

Best Regards,
Peter Stoev

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

[swarrenParticipant]

In case anyone else finds this, I was pulling data from a JSON source and had the date field formatted like ‘yyyy-MM-dd’. In the datafields for the data source I had to add a format option to the field or it was being adjusted based on my current timezone:

{name:’dueDate’, type: ‘string’, format: ‘yyyy-MM-dd’},

[Author]

Posts