Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dates in RSS Feed

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.

RSS Dates.jpg

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I got it.

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

View solution in original post

3 Replies
Anonymous
Not applicable
Author

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
Partner - Master
Partner - Master

Hi, try

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

rbecher
MVP
MVP

Hi Brian,

just use this expression:

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

- Ralf

Astrato.io Head of R&D