topic Re: Subtract seconds in QlikView https://community.qlik.com/t5/QlikView/Subtract-seconds/m-p/469063#M175222 <HTML><HEAD></HEAD><BODY><P>You may try the following expression:</P><P></P><P>Timestamp([Your Date or Timestamp]-Interval#('00:00:01','hh:mm:ss'),'dd/mm/yyyy hh:mm:ss')</P></BODY></HTML> Thu, 27 Dec 2012 20:31:15 GMT nagaiank 2012-12-27T20:31:15Z Subtract seconds https://community.qlik.com/t5/QlikView/Subtract-seconds/m-p/469062#M175221 <HTML><HEAD></HEAD><BODY><P>How subtract one second to a date?</P></BODY></HTML> Thu, 27 Dec 2012 20:08:49 GMT https://community.qlik.com/t5/QlikView/Subtract-seconds/m-p/469062#M175221 farolito20 2012-12-27T20:08:49Z Re: Subtract seconds https://community.qlik.com/t5/QlikView/Subtract-seconds/m-p/469063#M175222 <HTML><HEAD></HEAD><BODY><P>You may try the following expression:</P><P></P><P>Timestamp([Your Date or Timestamp]-Interval#('00:00:01','hh:mm:ss'),'dd/mm/yyyy hh:mm:ss')</P></BODY></HTML> Thu, 27 Dec 2012 20:31:15 GMT https://community.qlik.com/t5/QlikView/Subtract-seconds/m-p/469063#M175222 nagaiank 2012-12-27T20:31:15Z Re: Subtract seconds https://community.qlik.com/t5/QlikView/Subtract-seconds/m-p/469064#M175223 <HTML><HEAD></HEAD><BODY><P>hi</P><P>see attached file.</P><P>Timestamp(Timestamp([date1]-Interval#('00:00:01','hh:mm:ss'),'dd/mm/yyyy hh:mm:ss'))</P></BODY></HTML> Fri, 28 Dec 2012 09:25:55 GMT https://community.qlik.com/t5/QlikView/Subtract-seconds/m-p/469064#M175223 2012-12-28T09:25:55Z Re: Subtract seconds https://community.qlik.com/t5/QlikView/Subtract-seconds/m-p/469065#M175224 <HTML><HEAD></HEAD><BODY><P>try in the list box with this</P><P></P><P>=timestamp(Timestamp([date1]-Interval#('00:00:01','hh:mm:ss'),'dd/mm/yyyy hh:mm:ss'))</P><P></P><P>add timestamp.. </P><P>hope it helps you</P></BODY></HTML> Fri, 28 Dec 2012 09:34:06 GMT https://community.qlik.com/t5/QlikView/Subtract-seconds/m-p/469065#M175224 fdelacal 2012-12-28T09:34:06Z