Dates in RSS Feed

[Anonymous]

Can anyone help me figure out how to convert these RSS dates from this text format into actual dates in the script load? I don't care about the time info.

[Anonymous · Accepted solution]

I got it.

timestamp(timestamp#(mid(pubDate,6,20),'DD MMM YYYY hh:mm:ss'),'MM-DD-YYYY hh:mm:ss') as RSS_DateTime

[stabben23]

Hi, try

(date#(PurgeChar(left(mid(Datum,5) ,12),' '),'DDMMMYYYY')) as Date

[rbecher]

Hi Brian,

just use this expression:

Date(Date#(Mid(pubDate,6,11), 'DD MMM YYYY')) as pubDate,

- Ralf