converting date from xml file

[rbecher]

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

[rbecher · Accepted solution]

..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