Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
..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
..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