topic How to convert test format to time stamp format in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-test-format-to-time-stamp-format/m-p/1398949#M798807 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>How to convert below table into time stamp format </P><P></P><P></P><TABLE border="1" class="jiveBorder" height="104" style="border: 1px solid #000000; width: 229px; height: 106px;" width="227"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH></TR><TR><TD style="padding: 2px;">2017-11-28T00:15:00.000-05:00</TD></TR><TR><TD style="padding: 2px;">2017-11-28T00:30:00.000-05:00</TD></TR><TR><TD style="padding: 2px;">2017-11-28T00:55:00.000-05:00</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT vengadeshpalani 2020-11-25T16:16:04Z How to convert test format to time stamp format https://community.qlik.com/t5/QlikView/How-to-convert-test-format-to-time-stamp-format/m-p/1398949#M798807 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>How to convert below table into time stamp format </P><P></P><P></P><TABLE border="1" class="jiveBorder" height="104" style="border: 1px solid #000000; width: 229px; height: 106px;" width="227"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH></TR><TR><TD style="padding: 2px;">2017-11-28T00:15:00.000-05:00</TD></TR><TR><TD style="padding: 2px;">2017-11-28T00:30:00.000-05:00</TD></TR><TR><TD style="padding: 2px;">2017-11-28T00:55:00.000-05:00</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-convert-test-format-to-time-stamp-format/m-p/1398949#M798807 vengadeshpalani 2020-11-25T16:16:04Z Re: How to convert test format to time stamp format https://community.qlik.com/t5/QlikView/How-to-convert-test-format-to-time-stamp-format/m-p/1398950#M798808 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>timestamp(converttolocaltime(Date)) as Whatever,</P></BODY></HTML> Wed, 13 Dec 2017 21:43:48 GMT https://community.qlik.com/t5/QlikView/How-to-convert-test-format-to-time-stamp-format/m-p/1398950#M798808 m_woolf 2017-12-13T21:43:48Z