[SOLVED] DateFormat from WebService in grid

[PranKe01]

Hi there!

I'm trying to display a date from a WebService in a grid. The date comes in the ISO 8601 and looks like this: "2009-11-17T13:45:12.423".

var ds = new Ext.data.Store({
                            proxy: new Ext.data.MemoryProxy(data),
                            reader: new Ext.data.ArrayReader({id: 0}, [
                                {name: 'id', type:'int'},
                                ...
                                {name: 'date', type: 'date', dateFormat: 'Y-m-dTH:i:s.u'},
                                ...
                                {name: 'status', type:'string'}
                            ])
                        });
var colModel = new Ext.grid.ColumnModel([
                            ...
                            {header: "Date", width: 80, sortable: true, dataIndex: 'date'},
                            ...
                            {header: "Status", width: 80, sortable: true, dataIndex: 'status'}
                        ]);

The date is saved as dateTime in the SQL-Database and will be transformed in the webservice to the iso-format. Now my problem is that no data is displayed in my Adobe Air application! When I use the type 'string' for the date it is shown but with the ugly ISO-format
I also tried to change the dateFormat to: dateFormat: 'Y-m-d\\TH:i.u' and dateFormat: 'c' with no results.

Anyone knows what went wrong?

[PranKe01]

Does nobody got an answer or an idea? Thought this ISO norm is pretty much used?!

[Condor]

Date.parseDate uses 'new Function' to create the Date parser function.

Unfortunately, this is only allowed in Adobe AIR during script load, which means you have to declare all your date formats before Ext.onReady, e.g.

Date.createParser('c');
Ext.onReady(...);

(I would recommend using the 'c' date format instead of 'Y-m-d\\TH:i.u')

[PranKe01]

Ah - thanks =) I already seen it anywehere but when I tried it it doesn't work. Maybe because I changed something else?
Anyway - now the date will be shown but in a very long format. When trying to change it with:

{header: "Posteingang", width: 100, /*xtype: 'datecolumn',*/ sortable: true, dataIndex: 'anzahlneuernachrichten', renderer: Ext.util.Format.dateRenderer('d/m/Y')/*format: 'd/m/Y'*/}

it does not change the output Searching for whats going wrong I found a thread where stood that I have to add the following line before the onReady func:

Date.createNewFormat('d/m/Y');

But that gave me an error: "TypeError: Result of expression 'Date.createNewFormat' [undefined] is not a function."
When using

Date.createFormat('d/m/Y');

there is no error but again there is no change to the dateresult

[Condor]

No, it's:

Date.createParser('d/m/Y');

[PranKe01]

That didn't work for me in Adobe Air. But I found the solution here: http://www.extjs.com/forum/showthread.php?t=74310
You must add

Date.precompileFormats("d/m/Y");

before the onReady func

In Adobe Air it should finally look like:

Date.createParser('c');
Date.precompileFormats("d.m.Y");

Ext.onReady(function(){...}