RSS Date format in Qlikview

[Anonymous]

Hi,

I have imported the MS Office 365 rss feed into qlikview, but I have a problema with the date format.

Qlikview is not identifying it as a date format, just as normal text, so I cannot apply expressions that filter these dates such as just showing today's records, for example.

Feed:

http://rss.servicehealth.microsoftonline.com/feed/pt-PT/B7F70D7F85F11C8825780A4D1A857937/8p4qc7/gk1n...

Can someone tell me how can I do that please?

Attached the file. Thanks for the help!

[MK_QSL · Accepted solution]

Load your tables as below...

item:

Load

     *,

     TimeStamp(TimeStamp#(Left(Trim(SubField(pubDate,',',-1)),20),'DD MMM YYYY hh:mm:ss')) as DateTimeField,

     Date(Floor(TimeStamp#(Left(Trim(SubField(pubDate,',',-1)),20),'DD MMM YYYY hh:mm:ss'))) as DateField,

     Time(Frac(TimeStamp#(Left(Trim(SubField(pubDate,',',-1)),20),'DD MMM YYYY hh:mm:ss'))) as TimeField;

LOAD link,

    title,

    description,

    pubDate,

    %Key_rss_48AB09FE9E3B67F7    // Key to parent table: rss

FROM [http://rss.servicehealth.microsoftonline.com/feed/pt-PT/B7F70D7F85F11C8825780A4D1A857937/8p4qc7/gk1n...] (XmlSimple, Table is [rss/channel/item])

;

[Anonymous]

It works ! Many Thanks!