topic Dates in RSS Feed in QlikView https://community.qlik.com/t5/QlikView/Dates-in-RSS-Feed/m-p/478784#M689121 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P><IMG alt="RSS Dates.jpg" class="jive-image" src="/legacyfs/online/48545_RSS Dates.jpg" /></P></BODY></HTML> Mon, 04 Nov 2013 22:13:13 GMT Anonymous 2013-11-04T22:13:13Z Dates in RSS Feed https://community.qlik.com/t5/QlikView/Dates-in-RSS-Feed/m-p/478784#M689121 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P><IMG alt="RSS Dates.jpg" class="jive-image" src="/legacyfs/online/48545_RSS Dates.jpg" /></P></BODY></HTML> Mon, 04 Nov 2013 22:13:13 GMT https://community.qlik.com/t5/QlikView/Dates-in-RSS-Feed/m-p/478784#M689121 Anonymous 2013-11-04T22:13:13Z Re: Dates in RSS Feed https://community.qlik.com/t5/QlikView/Dates-in-RSS-Feed/m-p/478785#M689122 <HTML><HEAD></HEAD><BODY><P>I got it.</P><P></P><P>timestamp(timestamp#(mid(pubDate,6,20),'DD MMM YYYY hh:mm:ss'),'MM-DD-YYYY hh:mm:ss') as RSS_DateTime</P></BODY></HTML> Mon, 04 Nov 2013 22:40:36 GMT https://community.qlik.com/t5/QlikView/Dates-in-RSS-Feed/m-p/478785#M689122 Anonymous 2013-11-04T22:40:36Z Re: Dates in RSS Feed https://community.qlik.com/t5/QlikView/Dates-in-RSS-Feed/m-p/478786#M689123 <HTML><HEAD></HEAD><BODY><P>Hi, try</P><P></P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">date#</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">PurgeChar</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">left</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">mid</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Datum</SPAN><SPAN style="font-size: 8pt;">,5) ,12),' '),'DDMMMYYYY')) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Date </SPAN></P><P></P></BODY></HTML> Mon, 04 Nov 2013 22:45:03 GMT https://community.qlik.com/t5/QlikView/Dates-in-RSS-Feed/m-p/478786#M689123 stabben23 2013-11-04T22:45:03Z Re: Dates in RSS Feed https://community.qlik.com/t5/QlikView/Dates-in-RSS-Feed/m-p/478787#M689124 <HTML><HEAD></HEAD><BODY><P>Hi Brian,</P><P></P><P>just use this expression:</P><P></P><TABLE><TBODY><TR><TD></TD><TD>Date(Date#(Mid(pubDate,6,11), 'DD MMM YYYY')) as pubDate,</TD></TR></TBODY></TABLE><P></P><P>- Ralf</P></BODY></HTML> Mon, 04 Nov 2013 22:46:23 GMT https://community.qlik.com/t5/QlikView/Dates-in-RSS-Feed/m-p/478787#M689124 rbecher 2013-11-04T22:46:23Z