setDateFormat for server-side

Suite and Optimus Suite 5
#1

Hi,

I tried to set the format date from my grid:

gridUser.setColTypes("ed,ro,ed,dhxCalendar,dhxCalendar");
gridUser.setColSorting("str,str,str,date,date");
gridUser.setDateFormat("%d-%m-%Y %H:%i");

From database, I have format:

Y-m-d H:i

The problem is in my grid the ‘start_date’ column it’s empty.
When I’m editing in cell, I see the calendar, I can choose the time and date and I see it in the expected format:

%d-%m-%Y %H:%i

How can I make ‘start_date’ column to return the date in the expected format?

#2

You can change above code like next

gridUser.setDateFormat("%d-%m-%Y %H:%i", “%Y-%m-%d %H:%i”);

first parameter will define format for rendering in grid, second - format which need to be parsed from the xml data.

#3

Thank you very much Stanislav.

In my case I had to add the seconds too.

gridUser.setDateFormat("%d-%m-%Y %H:%i", “%Y-%m-%d %H:%i:%S”);

Regards,
Nicole