:: Forum >>

Date format problems

I wish to format dates in a grid using data rendered as xml by castor.

I'm using the following with AW 2.0:

grid.setCellFormat(dateFormat, colNum);
dateFormat.setTextFormat("dd-mmm-yy");
dateFormat.setDataFormat("ISO8601");

I'm getting '#ERR' in the column. I wondered if it could be due to the fact that the date strings seem to be missing the zone designators (eg. a trailing "+1:00"). Here is an example:

2006-05-16T09:50:44.000

I also saw an example which used the (erroneous) "ISO8061". I tried this but it did not work.

Can anyone advise me?

Regards,
Cal
Thursday, May 25, 2006
Currently ISO8601 format in AW expects the date EXACTLY as produced by .NET code, for example,

2003-10-27T00:00:00.0000000+01:00

for some reason I thought that this is kind of standard which is used by everyone else :-) In the future I will make parsing less strict but currently you have to make your dates exactly as in this example or modify date parsing regExp (/source/lib/formats/date.js, line 133).
Alex (ActiveWidgets)
Thursday, May 25, 2006

This topic is archived.


Back to support forum

Forum search