topic how do we format date in qlikview in QlikView https://community.qlik.com/t5/QlikView/how-do-we-format-date-in-qlikview/m-p/917399#M989364 <HTML><HEAD></HEAD><BODY><P>I have a column with timestamp values as&nbsp; below format How can i get the date from this value</P><P></P><P>Jul 15 11:06:15 EDT 2015</P><P></P><P></P><P>Also is there any link or suggestion from where we can check or learn the various techniques or concept around reading and formatting the timestamp values</P></BODY></HTML> Tue, 28 Jul 2015 09:00:18 GMT 2015-07-28T09:00:18Z how do we format date in qlikview https://community.qlik.com/t5/QlikView/how-do-we-format-date-in-qlikview/m-p/917399#M989364 <HTML><HEAD></HEAD><BODY><P>I have a column with timestamp values as&nbsp; below format How can i get the date from this value</P><P></P><P>Jul 15 11:06:15 EDT 2015</P><P></P><P></P><P>Also is there any link or suggestion from where we can check or learn the various techniques or concept around reading and formatting the timestamp values</P></BODY></HTML> Tue, 28 Jul 2015 09:00:18 GMT https://community.qlik.com/t5/QlikView/how-do-we-format-date-in-qlikview/m-p/917399#M989364 2015-07-28T09:00:18Z Re: how do we format date in qlikview https://community.qlik.com/t5/QlikView/how-do-we-format-date-in-qlikview/m-p/917400#M989366 <HTML><HEAD></HEAD><BODY><P>Try like this:</P><P>=DATE(Timestamp#(Replace('Jul 15 11:06:15 EDT 2015','EDT ',''),'MMM DD HH:MM:SS YYYY'),'YYYY-MM-DD')</P><P><IMG alt="2015-07-28_101252.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/94222_2015-07-28_101252.png" style="height: 135px; width: 620px;" /></P></BODY></HTML> Tue, 28 Jul 2015 09:13:34 GMT https://community.qlik.com/t5/QlikView/how-do-we-format-date-in-qlikview/m-p/917400#M989366 robert_mika 2015-07-28T09:13:34Z