topic parsing timestamp in QlikView https://community.qlik.com/t5/QlikView/parsing-timestamp/m-p/908912#M983610 <HTML><HEAD></HEAD><BODY><P>is there any article or blog on handling different type of timestamp string</P><P>i have a timestamp in below format . how can we parse it to timestamp</P><P style="font-size: 13.3333330154419px;"><STRONG>Mon 08 03 14:26:00 2015 EDT</STRONG></P></BODY></HTML> Tue, 04 Aug 2015 02:40:12 GMT 2015-08-04T02:40:12Z parsing timestamp https://community.qlik.com/t5/QlikView/parsing-timestamp/m-p/908912#M983610 <HTML><HEAD></HEAD><BODY><P>is there any article or blog on handling different type of timestamp string</P><P>i have a timestamp in below format . how can we parse it to timestamp</P><P style="font-size: 13.3333330154419px;"><STRONG>Mon 08 03 14:26:00 2015 EDT</STRONG></P></BODY></HTML> Tue, 04 Aug 2015 02:40:12 GMT https://community.qlik.com/t5/QlikView/parsing-timestamp/m-p/908912#M983610 2015-08-04T02:40:12Z Re: parsing timestamp https://community.qlik.com/t5/QlikView/parsing-timestamp/m-p/908913#M983611 <HTML><HEAD></HEAD><BODY><P>timestamp(timestamp#(keepchar('Mon 08 03 14:26:00 2015 EDT','0123456789'),'MMDDhhmmssYYYY'),'YYYY MMMM DD hh:mm:ss')</P><P></P><P>Change the last format string <SPAN style="font-size: 13.3333330154419px;">'YYYY MMMM DD hh:mm:ss'</SPAN> to whatever you need.</P></BODY></HTML> Tue, 04 Aug 2015 10:51:15 GMT https://community.qlik.com/t5/QlikView/parsing-timestamp/m-p/908913#M983611 Gysbert_Wassenaar 2015-08-04T10:51:15Z Re: parsing timestamp https://community.qlik.com/t5/QlikView/parsing-timestamp/m-p/908914#M983612 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Timestamp(Timestamp#(KeepChar('Mon 08 03 14:26:00 2015 EDT', '0123456789:'), 'MMDDhh:mm:ssYYYY'))</STRONG></P></BODY></HTML> Tue, 04 Aug 2015 11:25:19 GMT https://community.qlik.com/t5/QlikView/parsing-timestamp/m-p/908914#M983612 sunny_talwar 2015-08-04T11:25:19Z