topic Re: DateTime Calculation in QlikView https://community.qlik.com/t5/QlikView/DateTime-Calculation/m-p/857683#M300458 <HTML><HEAD></HEAD><BODY><P>Thank you so much.</P></BODY></HTML> Mon, 06 Apr 2015 10:14:25 GMT 2015-04-06T10:14:25Z DateTime Calculation https://community.qlik.com/t5/QlikView/DateTime-Calculation/m-p/857677#M300452 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">I want to add 100 secs to the datetime&nbsp; for eg. 02/10/2014 5:40:08 PM so that it becomes 02/10/2014 5:41:48 PM. Any help is appreciated</SPAN></P></BODY></HTML> Mon, 06 Apr 2015 09:31:49 GMT https://community.qlik.com/t5/QlikView/DateTime-Calculation/m-p/857677#M300452 2015-04-06T09:31:49Z Re: DateTime Calculation https://community.qlik.com/t5/QlikView/DateTime-Calculation/m-p/857678#M300453 <HTML><HEAD></HEAD><BODY><P>Hi ramko,</P><P></P><P>try like this.....</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">timestamp(MyDate + 100/86400)</SPAN></P></BODY></HTML> Mon, 06 Apr 2015 09:38:20 GMT https://community.qlik.com/t5/QlikView/DateTime-Calculation/m-p/857678#M300453 2015-04-06T09:38:20Z Re: DateTime Calculation https://community.qlik.com/t5/QlikView/DateTime-Calculation/m-p/857679#M300454 <HTML><HEAD></HEAD><BODY><P>=Timestamp(now()+0.0011574074087548)</P></BODY></HTML> Mon, 06 Apr 2015 09:43:03 GMT https://community.qlik.com/t5/QlikView/DateTime-Calculation/m-p/857679#M300454 Anonymous 2015-04-06T09:43:03Z Re: DateTime Calculation https://community.qlik.com/t5/QlikView/DateTime-Calculation/m-p/857680#M300455 <HTML><HEAD></HEAD><BODY><P>this expression will give u 100 secs forward time</P></BODY></HTML> Mon, 06 Apr 2015 09:43:50 GMT https://community.qlik.com/t5/QlikView/DateTime-Calculation/m-p/857680#M300455 Anonymous 2015-04-06T09:43:50Z Re: DateTime Calculation https://community.qlik.com/t5/QlikView/DateTime-Calculation/m-p/857681#M300456 <HTML><HEAD></HEAD><BODY><P>replace now() by field name or variable name and you will get the answer </P></BODY></HTML> Mon, 06 Apr 2015 09:44:30 GMT https://community.qlik.com/t5/QlikView/DateTime-Calculation/m-p/857681#M300456 Anonymous 2015-04-06T09:44:30Z Re: DateTime Calculation https://community.qlik.com/t5/QlikView/DateTime-Calculation/m-p/857682#M300457 <HTML><HEAD></HEAD><BODY><P>when you add 1 it is 1 days </P><P>so you have to fraction it with 24 hours*60 Minutes*60Secs =<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">86400</SPAN></P></BODY></HTML> Mon, 06 Apr 2015 09:46:16 GMT https://community.qlik.com/t5/QlikView/DateTime-Calculation/m-p/857682#M300457 Anonymous 2015-04-06T09:46:16Z Re: DateTime Calculation https://community.qlik.com/t5/QlikView/DateTime-Calculation/m-p/857683#M300458 <HTML><HEAD></HEAD><BODY><P>Thank you so much.</P></BODY></HTML> Mon, 06 Apr 2015 10:14:25 GMT https://community.qlik.com/t5/QlikView/DateTime-Calculation/m-p/857683#M300458 2015-04-06T10:14:25Z