problem with date format

[gusanomalyParticipant]

Hi,

I’m using this grid with many colums, in one is width date format seted as format: ‘dd/MM/yyyy’.
When open the grid width data from database no use the format that I seted, the date format from my database is: yyyy-mm-dd h:i:s

So, I’ve defined in datafields like this: { name: ‘date_val’, type: ‘date’, format: ‘dd/MM/yyyy’},
And in grid also put the next: cellsformat: ‘dd/MM/yyyy’

When i get the data grid using getboundrows and show the data with alert() it show this: Mon Feb 02 2015 00:00:00 GMT-0300

Thank you and i hope write clearly!
Gustav.

[Peter StoevKeymaster]

Hi Gustav,

The data field’s format should be equal to your DB’s format. The column’s cellsformat should be the format which you want to be displayed. In Grid, dates are JavaScript date Object’s i.e they’re store as Mon Feb 02 2015 00:00:00 GMT-0300. If you want to get the display text of a given cell, use “getcelltext”.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[gusanomalyParticipant]

Hi,

Works perfect!

Thank you,
Gustav.

[Author]

Posts