[CLOSED] DateTime format on Grid problem

[caha76]

I'm retriving data from sql server stored procedure, ono of my fields return as datetime type.

I'm trying to configure my dynamic grid (store and columns) but i don't know why.

Test Cases:

1:
stResult.AddField(new RecordField(dataIndex, RecordFieldType.Date));
Result: date column on grid is empty (value is undefined)

2:
stResult.AddField(new RecordField(dataIndex, RecordFieldType.Date, 'Y/M/d'));
Result: date column on grid is empty (value is undefined)

3: stResult.AddField(new RecordField(dataIndex, RecordFieldType.Auto));
column.Renderer.Format = RendererFormat.Date; ('d/m/Y')
Result: date column on grid is displayed but in incorrect form (m/d/y)

Sql server info
- database Collation: SQL_Latin1_General_CP1_CI_AS
- database langauje: english

Could you help me pleas ?

[caha76]

Close this ticket i found an error on my logic, sorry.