dhtmlxGrid doesn't sort by Date

Suite and Optimus Suite 5
#1

Hi,

I have the follow grid:

[code]{ view: ‘grid’,
fields: [
{
id:“fecha”,
label:“Fecha”,
width:55,
template:"#fecha#",
},
{
id:“col1”,
label:“Col1”,
width:50,
template:"#col1#"
},
{
id:“col2”,
label:“Col2”,
width:65,
template:"#col2#"
},
{
id:“col3”,
label:“Col3”,
width:40,
template:"#col3#"
},
{
id:“col4”,
label:“Col4”,
width:50,
template:"#col4#"
},
{
id:“col5”,
label:“Col5”,
width:45,
template:"#col5#"
},
{
id:“col6”,
label:“Col6”,
width:55,
template:"#col6#"
},
], select: true, header: true, scroll:“y”, id: gridDetalleEvoDiariaAltas’

      }[/code]

I want to sort the grid by Date for the first column, but it sorts by string. I have tried this:

$$('gridDetalleEvoDiariaAltas').setColSorting("date,int,int,int,int,int,int");

The format data of this colum is: dd/MM

There is an issue?

Regards

#2

in case using dhxCalendar exCell you need to set the format of date with setDateFormat() method
For all other exCells only the “dd/mm/yyyy” format is supported.