topic Need to add hours in QlikView https://community.qlik.com/t5/QlikView/Need-to-add-hours/m-p/332432#M1174187 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 12pt;">Currently my MSSQL column for time is past due 8hours, therefore I need to add another 8hours</SPAN></P><P></P><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 12pt;">eg: current 07:28:30 need to be 15<SPAN style="color: #000000; font-family: 'Courier New';">:28:30</SPAN></SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: 'Courier New';">Below are the script that been tried but not meet my needs<BR /></SPAN></P><P></P><P><SPAN style="font-size: 12pt;"><SPAN style="color: blue; font-family: 'Courier New';">&nbsp;&nbsp;&nbsp;&nbsp; Time</SPAN><SPAN style="color: black; font-family: 'Courier New';">((</SPAN><SPAN style="color: maroon; font-family: 'Courier New';">"TMS &amp; WMS Push Date"</SPAN><SPAN style="color: black; font-family: 'Courier New';">),'hh:mm:ss')+8:00:00</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: blue; font-family: 'Courier New';">Time</SPAN><SPAN style="color: black; font-family: 'Courier New';">((</SPAN><SPAN style="color: maroon; font-family: 'Courier New';">"TMS &amp; WMS Push Date"</SPAN><SPAN style="color: black; font-family: 'Courier New';">),'hh:mm:ss')+8</SPAN></SPAN></P><P></P><P><SPAN style="color: black; font-size: 12pt; font-family: 'Courier New';">Please advise.<BR /></SPAN></P></BODY></HTML> Fri, 01 Jun 2012 03:56:38 GMT 2012-06-01T03:56:38Z Need to add hours https://community.qlik.com/t5/QlikView/Need-to-add-hours/m-p/332432#M1174187 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 12pt;">Currently my MSSQL column for time is past due 8hours, therefore I need to add another 8hours</SPAN></P><P></P><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 12pt;">eg: current 07:28:30 need to be 15<SPAN style="color: #000000; font-family: 'Courier New';">:28:30</SPAN></SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: 'Courier New';">Below are the script that been tried but not meet my needs<BR /></SPAN></P><P></P><P><SPAN style="font-size: 12pt;"><SPAN style="color: blue; font-family: 'Courier New';">&nbsp;&nbsp;&nbsp;&nbsp; Time</SPAN><SPAN style="color: black; font-family: 'Courier New';">((</SPAN><SPAN style="color: maroon; font-family: 'Courier New';">"TMS &amp; WMS Push Date"</SPAN><SPAN style="color: black; font-family: 'Courier New';">),'hh:mm:ss')+8:00:00</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: blue; font-family: 'Courier New';">Time</SPAN><SPAN style="color: black; font-family: 'Courier New';">((</SPAN><SPAN style="color: maroon; font-family: 'Courier New';">"TMS &amp; WMS Push Date"</SPAN><SPAN style="color: black; font-family: 'Courier New';">),'hh:mm:ss')+8</SPAN></SPAN></P><P></P><P><SPAN style="color: black; font-size: 12pt; font-family: 'Courier New';">Please advise.<BR /></SPAN></P></BODY></HTML> Fri, 01 Jun 2012 03:56:38 GMT https://community.qlik.com/t5/QlikView/Need-to-add-hours/m-p/332432#M1174187 2012-06-01T03:56:38Z Need to add hours https://community.qlik.com/t5/QlikView/Need-to-add-hours/m-p/332433#M1174188 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this Interval('7:00:00' + '08:00:00','hh:mm:ss')</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Fri, 01 Jun 2012 04:02:26 GMT https://community.qlik.com/t5/QlikView/Need-to-add-hours/m-p/332433#M1174188 Sokkorn 2012-06-01T04:02:26Z