topic Timestamp Format problem in QlikView https://community.qlik.com/t5/QlikView/Timestamp-Format-problem/m-p/1335685#M614754 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a problem wih the timestamp format, this is my script:</P><P></P><P>if(Start_time = 'leer',Previous(<SPAN style="font-size: 13.3333px;">Start_time </SPAN>)-Time(1/1440,'mm'),(<SPAN style="font-size: 13.3333px;">Start_time </SPAN>)) as <SPAN style="font-size: 13.3333px;">Start_time,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>I always get the previous time - 1 min not in a timestamp format.</P><P></P><P><IMG alt="Start_time.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166203_Start_time.PNG" style="height: auto;" /></P><P></P><P>How can I get always a timestamp?</P><P></P><P>Thank you! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 08 Jun 2017 12:56:30 GMT alexandermllr 2017-06-08T12:56:30Z Timestamp Format problem https://community.qlik.com/t5/QlikView/Timestamp-Format-problem/m-p/1335685#M614754 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a problem wih the timestamp format, this is my script:</P><P></P><P>if(Start_time = 'leer',Previous(<SPAN style="font-size: 13.3333px;">Start_time </SPAN>)-Time(1/1440,'mm'),(<SPAN style="font-size: 13.3333px;">Start_time </SPAN>)) as <SPAN style="font-size: 13.3333px;">Start_time,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>I always get the previous time - 1 min not in a timestamp format.</P><P></P><P><IMG alt="Start_time.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166203_Start_time.PNG" style="height: auto;" /></P><P></P><P>How can I get always a timestamp?</P><P></P><P>Thank you! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 08 Jun 2017 12:56:30 GMT https://community.qlik.com/t5/QlikView/Timestamp-Format-problem/m-p/1335685#M614754 alexandermllr 2017-06-08T12:56:30Z Re: Timestamp Format problem https://community.qlik.com/t5/QlikView/Timestamp-Format-problem/m-p/1335686#M614755 <HTML><HEAD></HEAD><BODY><P>TIMESTAMP is just a formatting. Calculation itself is done on pure numbers.</P><P>Suggest to use</P><P>TIMESTAMP(if(Start_time = 'leer',Previous(<SPAN style="font-size: 13.3333px;">Start_time </SPAN>)-(1/1440),(<SPAN style="font-size: 13.3333px;">Start_time </SPAN>))) as <SPAN style="font-size: 13.3333px;">Start_time</SPAN></P><P><SPAN style="font-size: 13.3333px;">instead.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Peter</SPAN></P></BODY></HTML> Thu, 08 Jun 2017 13:07:11 GMT https://community.qlik.com/t5/QlikView/Timestamp-Format-problem/m-p/1335686#M614755 prieper 2017-06-08T13:07:11Z Re: Timestamp Format problem https://community.qlik.com/t5/QlikView/Timestamp-Format-problem/m-p/1335687#M614756 <HTML><HEAD></HEAD><BODY><P>Thank you very much !! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 08 Jun 2017 13:09:52 GMT https://community.qlik.com/t5/QlikView/Timestamp-Format-problem/m-p/1335687#M614756 alexandermllr 2017-06-08T13:09:52Z