topic Re: Converting Timestamp to Date format in QlikView https://community.qlik.com/t5/QlikView/Converting-Timestamp-to-Date-format/m-p/98438#M15733 <HTML><HEAD></HEAD><BODY><P>Try this - </P><P>Date(Date#(Left(Date,9), 'DDMMMYYYY'), 'DD/MM/YYYY')</P></BODY></HTML> Fri, 21 Sep 2018 17:58:36 GMT neelamsaroha157 2018-09-21T17:58:36Z Converting Timestamp to Date format https://community.qlik.com/t5/QlikView/Converting-Timestamp-to-Date-format/m-p/98437#M15732 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have the date in the format "<SPAN style="color: #333333; font-family: Tahoma;">01AUG2017:09:24:17.000000</SPAN>". Not sure how to convert into "DD-MMM-YY".</P><P>Can any one please help me with this?</P><P></P><P> Attached the sample data and QVW file.</P><P></P><P>Thanks in advance!</P><P></P><P>Cheers,</P><P>Varun</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P></BODY></HTML> Fri, 21 Sep 2018 17:49:33 GMT https://community.qlik.com/t5/QlikView/Converting-Timestamp-to-Date-format/m-p/98437#M15732 varunreddy 2018-09-21T17:49:33Z Re: Converting Timestamp to Date format https://community.qlik.com/t5/QlikView/Converting-Timestamp-to-Date-format/m-p/98438#M15733 <HTML><HEAD></HEAD><BODY><P>Try this - </P><P>Date(Date#(Left(Date,9), 'DDMMMYYYY'), 'DD/MM/YYYY')</P></BODY></HTML> Fri, 21 Sep 2018 17:58:36 GMT https://community.qlik.com/t5/QlikView/Converting-Timestamp-to-Date-format/m-p/98438#M15733 neelamsaroha157 2018-09-21T17:58:36Z Re: Converting Timestamp to Date format https://community.qlik.com/t5/QlikView/Converting-Timestamp-to-Date-format/m-p/98439#M15734 <HTML><HEAD></HEAD><BODY><P>Thanks Neelam for the quick response <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Cheers,</P><P>Varun</P></BODY></HTML> Fri, 21 Sep 2018 18:03:06 GMT https://community.qlik.com/t5/QlikView/Converting-Timestamp-to-Date-format/m-p/98439#M15734 varunreddy 2018-09-21T18:03:06Z