topic Re: TimeStamp Function in QlikView https://community.qlik.com/t5/QlikView/TimeStamp-Function/m-p/259116#M584741 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>the chunk of code </P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD>TIMESTAMPDIFF(4, char(TIMESTAMP(( (CASE WHEN(1-1=0) THEN (TIMESTAMP(current date, current time)) ELSE <P>("HistoryTable".START_TIME) END) ))-TIMESTAMP(( "HistoryTable".END_TIME ))))</P></TD></TR></TBODY></TABLE></BLOCKQUOTE><P>is basically trying to calculate the difference in dates "HistoryTable".START_TIME and "HistoryTable".END_TIME.</P><P>You can use </P><P>Load&nbsp; ("HistoryTable".END_TIME - HistoryTable".START_TIME ) as DiffDays from table..</P><P>in qlikview, but needs to take care of the system date fromat and date format of the data in the table.</P><P>As you know when you load date in Qlikview it will interpret the date in the local system date fromat that you can see in the first tab of the script.</P><P>Cheers.</P></BODY></HTML> Wed, 14 Sep 2011 09:21:51 GMT 2011-09-14T09:21:51Z TimeStamp Function https://community.qlik.com/t5/QlikView/TimeStamp-Function/m-p/259115#M584740 <HTML><HEAD></HEAD><BODY><P>Could you please help me in converting following below BO query into Qlikview</P><P></P><P></P><P>TIMESTAMPDIFF(4, char(TIMESTAMP(( (CASE WHEN(1-1=0) THEN (TIMESTAMP(current date, current time)) ELSE </P><P>("HistoryTable".START_TIME) END) ))-TIMESTAMP(( "HistoryTable".END_TIME ))))</P></BODY></HTML> Wed, 14 Sep 2011 03:48:41 GMT https://community.qlik.com/t5/QlikView/TimeStamp-Function/m-p/259115#M584740 2011-09-14T03:48:41Z Re: TimeStamp Function https://community.qlik.com/t5/QlikView/TimeStamp-Function/m-p/259116#M584741 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>the chunk of code </P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD>TIMESTAMPDIFF(4, char(TIMESTAMP(( (CASE WHEN(1-1=0) THEN (TIMESTAMP(current date, current time)) ELSE <P>("HistoryTable".START_TIME) END) ))-TIMESTAMP(( "HistoryTable".END_TIME ))))</P></TD></TR></TBODY></TABLE></BLOCKQUOTE><P>is basically trying to calculate the difference in dates "HistoryTable".START_TIME and "HistoryTable".END_TIME.</P><P>You can use </P><P>Load&nbsp; ("HistoryTable".END_TIME - HistoryTable".START_TIME ) as DiffDays from table..</P><P>in qlikview, but needs to take care of the system date fromat and date format of the data in the table.</P><P>As you know when you load date in Qlikview it will interpret the date in the local system date fromat that you can see in the first tab of the script.</P><P>Cheers.</P></BODY></HTML> Wed, 14 Sep 2011 09:21:51 GMT https://community.qlik.com/t5/QlikView/TimeStamp-Function/m-p/259116#M584741 2011-09-14T09:21:51Z