Use DateTime format in the Grid

Hi!
If i understood correctly I can not use DateTime format data in the Grid? If I wrong someone can correct me.

You can set needed DateTime format in column setting of grid, like this:
columns: [
{id: ‘my_date_time’, type:‘date’, dateFormat:’%H:%i %d.%m.%Y’, header:[{text: ‘Date Time’}]}
]
It’s documented here:
https://docs.dhtmlx.com/suite/grid__configuration.html#columneditors

But this setting works only for sorting of rows, not for editing of cell, because editor’s calendar widget has not timepicker. See this snippet:
https://snippet.dhtmlx.com/nd8aydll

1 Like

Is there a workaround for timePicker?

Unfortunately it is not available to display the timepicker in the grid datePicker editor.

Any updates on potentially updating the widget to include time picker from the calendar component?

https://dhtmlx.com/docs/products/dhtmlxCalendar/

Unfortunately currently there are no news about that functionality in the dhtmlxGrid datapicker editor.
I’ll inform here about the probable progress about that issue.