Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
bgarland
Contributor III

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

Tags (2)
1 Solution

Accepted Solutions
bgarland
Contributor III

Re: Dates in RSS Feed

I got it.

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

3 Replies
bgarland
Contributor III

Re: Dates in RSS Feed

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
Honored Contributor

Re: Dates in RSS Feed

Hi, try

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

MVP
MVP

Re: Dates in RSS Feed

Hi Brian,

just use this expression:

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

- Ralf

Community Browser