Use DateTime format in the Grid

Suite and Optimus Suite 6
#1

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

#2

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
#3

Is there a workaround for timePicker?

#4

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

#5

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

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

#6

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.

#7

We have added the timepicker to the dhx.Grid datePicker editor in our latest dhx.Suite update (v8.0).
You can test it here:

Please, download the latest available dhx.Suite build from your client’s area to get that fix.
Thank you for your request and patience.
Best regards.