topic Re: convert timestamp to string in QlikView https://community.qlik.com/t5/QlikView/convert-timestamp-to-string/m-p/298896#M1193674 <HTML><HEAD></HEAD><BODY><P>i think something like this could help you</P><P></P><P>= left(monthname(date_created),3) &amp;'-'&amp;day(date_created)&amp;'-'&amp;year(date_created)</P></BODY></HTML> Fri, 22 Jul 2011 11:17:52 GMT 2011-07-22T11:17:52Z convert timestamp to string https://community.qlik.com/t5/QlikView/convert-timestamp-to-string/m-p/298895#M1193673 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I have 2 columns&nbsp; datatext(datatype varchar2) and date_created(timestamp)</P><P></P><P>the sample data for the columns </P><P></P><P>datatext&nbsp; - apr-23-2011</P><P></P><P>date_created - 4/23/2011 1:56:19 PM</P><P></P><P>Now i want convert date_created format to datatext&nbsp; ..</P><P></P><P>How do i do that ?</P><P></P><P>Please Help...</P></BODY></HTML> Fri, 22 Jul 2011 05:41:49 GMT https://community.qlik.com/t5/QlikView/convert-timestamp-to-string/m-p/298895#M1193673 2011-07-22T05:41:49Z Re: convert timestamp to string https://community.qlik.com/t5/QlikView/convert-timestamp-to-string/m-p/298896#M1193674 <HTML><HEAD></HEAD><BODY><P>i think something like this could help you</P><P></P><P>= left(monthname(date_created),3) &amp;'-'&amp;day(date_created)&amp;'-'&amp;year(date_created)</P></BODY></HTML> Fri, 22 Jul 2011 11:17:52 GMT https://community.qlik.com/t5/QlikView/convert-timestamp-to-string/m-p/298896#M1193674 2011-07-22T11:17:52Z Re: convert timestamp to string https://community.qlik.com/t5/QlikView/convert-timestamp-to-string/m-p/298897#M1193676 <HTML><HEAD></HEAD><BODY><P>What about this:</P><P></P><P>= Text(Date(Date#([date_created]), 'MMM-DD-YYYY'))</P></BODY></HTML> Fri, 22 Jul 2011 11:30:14 GMT https://community.qlik.com/t5/QlikView/convert-timestamp-to-string/m-p/298897#M1193676 Anonymous 2011-07-22T11:30:14Z