topic strange timestamp format in QlikView https://community.qlik.com/t5/QlikView/strange-timestamp-format/m-p/1232289#M862909 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>I'm working with an api that outputs a timestamp in the below formula. does anyone know how I might get the time and date out in the following formats?</P><P></P><P>current timestamp format: Fri Oct 02 13:01:18 +0000 2015</P><P>desired date format: DD/MM/YYYY</P><P>desired time format: hh:mm:ss</P><P></P><P>cheers all</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT samuel_brierley 2020-11-25T16:16:04Z strange timestamp format https://community.qlik.com/t5/QlikView/strange-timestamp-format/m-p/1232289#M862909 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>I'm working with an api that outputs a timestamp in the below formula. does anyone know how I might get the time and date out in the following formats?</P><P></P><P>current timestamp format: Fri Oct 02 13:01:18 +0000 2015</P><P>desired date format: DD/MM/YYYY</P><P>desired time format: hh:mm:ss</P><P></P><P>cheers all</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/strange-timestamp-format/m-p/1232289#M862909 samuel_brierley 2020-11-25T16:16:04Z Re: strange timestamp format https://community.qlik.com/t5/QlikView/strange-timestamp-format/m-p/1232290#M862910 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=Date(Date#(MID('Fri Oct 02 13:01:18 +0000 2015',5,3) &amp;&nbsp; MID('Fri Oct 02 13:01:18 +0000 2015',9,2) &amp; Right('Fri Oct 02 13:01:18 +0000 2015',4),'MMMDDYYYY'),'DD/MM/YYYY')</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=Time(Time#(MID('Fri Oct 02 13:01:18 +0000 2015',12,8),'hh:mm:ss'))</P></BODY></HTML> Wed, 11 Jan 2017 15:58:51 GMT https://community.qlik.com/t5/QlikView/strange-timestamp-format/m-p/1232290#M862910 MK_QSL 2017-01-11T15:58:51Z