seconds in setDateFormat

Suite and Optimus Suite 5
#1

Hi,

I often have ‘complete timestamps’ in a grid with also seconds like: ‘2011-11-16 18:12:03’
I cannot find a format string for seconds in docs.dhtmlx.com/doku.php?id=dhtm … ate_values
Is it possible in any way to use somthing like:

grid.setDateFormat("%Y-%m-%d %H:%i:%s");

Thanks in advance,
FranX

#2

I noticed it’s a problem with readonly cells.
I’ve got the following in xml:

    <column id="Created" width="150" type="ro" sort="date" align="right">Created</column>
    <column id="Changed" width="150" type="dhxCalendar" sort="date" align="right">Changed</column>

    <cell>2011-11-16 15:06:14</cell>
    <cell>2011-11-16 15:06:14</cell>

My grid (pro version 3) uses:

grid.setDateFormat("%Y-%m-%d %H:%i:%s", "%Y-%m-%d %H:%i:%s");

The first column in the example above does’t sort right, the second does.
I’ve got the need to also be able to sort readonly fields, the sort attribute says it’s a date field, so what might be the problem?

TIA,
FranX