converting date from xml file

rbecher — Fri, 26 Mar 2010 14:49:55 GMT

Hello,

I have to read a xml file with a date value in this format:

'Thu Apr 01 00:00:00 CEST 2010'
'Fri Jan 01 00:00:00 CET 2010'

I've tried without the time like this

'Thu Apr 01 2010'
'Fri Jan 01 2010'

date(date#(field, 'WWW MMM DD YYYY'))

but can not convert it to a date. What is wrong?

- Ralf

AW:converting date from xml file

rbecher — Tue, 04 May 2010 23:06:57 GMT

..sometimes you do not see the forest for the trees.

I just had to strip the redundant day (WWW) like this:

date(date#(trim(mid(field, 5, 7) & right(field, 4)), 'MMM DD YYYY')) as startPeriod

- Ralf