topic Re: dateadd seconds in QlikView https://community.qlik.com/t5/QlikView/dateadd-seconds/m-p/409953#M152464 <HTML><HEAD></HEAD><BODY><P>If it's a string you first need to make it a date. Something like this I think:</P><P></P><P>MyNewDateTime = date#('2/31/1969 6:00 pm','D/MM/YYYY hh:mm TT') + MyfieldInSeconds/8640</P><P><CODE class="jive-code"><BR /></CODE></P></BODY></HTML> Fri, 12 Oct 2012 17:26:29 GMT Gysbert_Wassenaar 2012-10-12T17:26:29Z dateadd seconds https://community.qlik.com/t5/QlikView/dateadd-seconds/m-p/409948#M152459 <HTML><HEAD></HEAD><BODY><P>Hello that's my first time here! I have a sql column in seconds (10 characters) and i need to add (dateadd in sql), the seconds to one date ex: (2/31/1969 6:00 pm) to extract the spend time since that date ex: dateadd([second],columnname,'12/31/1969 6:00 pm') ¿it's there a way to do this in QlikView? Regards!</P></BODY></HTML> Fri, 12 Oct 2012 16:55:58 GMT https://community.qlik.com/t5/QlikView/dateadd-seconds/m-p/409948#M152459 2012-10-12T16:55:58Z Re: dateadd seconds https://community.qlik.com/t5/QlikView/dateadd-seconds/m-p/409949#M152460 <HTML><HEAD></HEAD><BODY><P>Divide the number of seconds by 86400 and add that to a date: MyNewDateTime = MyDateTime + Seconds/86400</P></BODY></HTML> Fri, 12 Oct 2012 17:06:32 GMT https://community.qlik.com/t5/QlikView/dateadd-seconds/m-p/409949#M152460 Gysbert_Wassenaar 2012-10-12T17:06:32Z Re: dateadd seconds https://community.qlik.com/t5/QlikView/dateadd-seconds/m-p/409950#M152461 <HTML><HEAD></HEAD><BODY><P>Thanks! I have a question i have my start datetime field with the format "am/pm" ¿how it works? MyNewDateTime = 2/31/1969 6:00 pm + MyfieldInSeconds/86400 ??? Regards!</P></BODY></HTML> Fri, 12 Oct 2012 17:19:40 GMT https://community.qlik.com/t5/QlikView/dateadd-seconds/m-p/409950#M152461 2012-10-12T17:19:40Z Re: dateadd seconds https://community.qlik.com/t5/QlikView/dateadd-seconds/m-p/409951#M152462 <HTML><HEAD></HEAD><BODY><P>Thanks! I have a question i have my start datetime field with the format "am/pm" ¿how it works? MyNewDateTime = 2/31/1969 6:00 pm + MyfieldInSeconds/86400 ??? Regards!</P></BODY></HTML> Fri, 12 Oct 2012 17:20:00 GMT https://community.qlik.com/t5/QlikView/dateadd-seconds/m-p/409951#M152462 2012-10-12T17:20:00Z Re: dateadd seconds https://community.qlik.com/t5/QlikView/dateadd-seconds/m-p/409952#M152463 <HTML><HEAD></HEAD><BODY><P>Use Date# function to format it to the date format that you going to provide as input.</P><P>Qlikview itself process 1 days as integer 1.</P><P>You can check it by Num(Today()).</P></BODY></HTML> Fri, 12 Oct 2012 17:26:26 GMT https://community.qlik.com/t5/QlikView/dateadd-seconds/m-p/409952#M152463 CELAMBARASAN 2012-10-12T17:26:26Z Re: dateadd seconds https://community.qlik.com/t5/QlikView/dateadd-seconds/m-p/409953#M152464 <HTML><HEAD></HEAD><BODY><P>If it's a string you first need to make it a date. Something like this I think:</P><P></P><P>MyNewDateTime = date#('2/31/1969 6:00 pm','D/MM/YYYY hh:mm TT') + MyfieldInSeconds/8640</P><P><CODE class="jive-code"><BR /></CODE></P></BODY></HTML> Fri, 12 Oct 2012 17:26:29 GMT https://community.qlik.com/t5/QlikView/dateadd-seconds/m-p/409953#M152464 Gysbert_Wassenaar 2012-10-12T17:26:29Z Re: dateadd seconds https://community.qlik.com/t5/QlikView/dateadd-seconds/m-p/409954#M152465 <HTML><HEAD></HEAD><BODY><P>Use the functions: ConvertToLocalTime(timestamp(25569+YOURFIELD/24/60/60),'GMT-06:00') where the 'GMT-06:00' it's yout UTC zone enjoy!</P></BODY></HTML> Fri, 12 Oct 2012 19:23:25 GMT https://community.qlik.com/t5/QlikView/dateadd-seconds/m-p/409954#M152465 2012-10-12T19:23:25Z