topic Re: Adding up dates as a number in the data load editor in App Development https://community.qlik.com/t5/App-Development/Adding-up-dates-as-a-number-in-the-data-load-editor/m-p/879242#M12192 <HTML><HEAD></HEAD><BODY><P>Hiya</P><P></P><P>awesome ta xxx</P><P></P><P>worked a treat</P><P></P><P>Kind Regards </P><P>Joeybird</P></BODY></HTML> Wed, 06 May 2015 09:09:36 GMT joeybird 2015-05-06T09:09:36Z Adding up dates as a number in the data load editor https://community.qlik.com/t5/App-Development/Adding-up-dates-as-a-number-in-the-data-load-editor/m-p/879238#M12188 <HTML><HEAD></HEAD><BODY><P>Hiya</P><P></P><P>I would like the following in my data load statement...dates to add up to a total number of days ...the in the "total number of days" new column</P><P></P><P>sum(if(DateOrderCompleted) - (DateOrderReceived) as [TotalNumberOfDays],</P><P></P><P>I cant seem to crack it.</P><P></P><P>please help </P><P></P><P>Kind regards</P><P></P><P>joeybird</P></BODY></HTML> Tue, 05 May 2015 14:00:25 GMT https://community.qlik.com/t5/App-Development/Adding-up-dates-as-a-number-in-the-data-load-editor/m-p/879238#M12188 joeybird 2015-05-05T14:00:25Z Re: Adding up dates as a number in the data load editor https://community.qlik.com/t5/App-Development/Adding-up-dates-as-a-number-in-the-data-load-editor/m-p/879239#M12189 <HTML><HEAD></HEAD><BODY><P>Remove "if":</P><P>sum(DateOrderCompleted - DateOrderReceived) as [TotalNumberOfDays],</P></BODY></HTML> Tue, 05 May 2015 14:02:26 GMT https://community.qlik.com/t5/App-Development/Adding-up-dates-as-a-number-in-the-data-load-editor/m-p/879239#M12189 Anonymous 2015-05-05T14:02:26Z Re: Adding up dates as a number in the data load editor https://community.qlik.com/t5/App-Development/Adding-up-dates-as-a-number-in-the-data-load-editor/m-p/879240#M12190 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Interval(DateOrderCompleted - <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">DateOrderReceived,'DD') as TotalNumberOfDays</SPAN></SPAN></P></BODY></HTML> Tue, 05 May 2015 14:04:49 GMT https://community.qlik.com/t5/App-Development/Adding-up-dates-as-a-number-in-the-data-load-editor/m-p/879240#M12190 MK_QSL 2015-05-05T14:04:49Z Re: Adding up dates as a number in the data load editor https://community.qlik.com/t5/App-Development/Adding-up-dates-as-a-number-in-the-data-load-editor/m-p/879241#M12191 <HTML><HEAD></HEAD><BODY><P>Hi Joanna,</P><P></P><P>Why not simply:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Date((DateOrderCompleted)) - Date((DateOrderReceived)) as TotalNumberOfDays</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Lemme know.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Regards,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">N<BR /></SPAN></P></BODY></HTML> Tue, 05 May 2015 22:57:42 GMT https://community.qlik.com/t5/App-Development/Adding-up-dates-as-a-number-in-the-data-load-editor/m-p/879241#M12191 nico_ilog 2015-05-05T22:57:42Z Re: Adding up dates as a number in the data load editor https://community.qlik.com/t5/App-Development/Adding-up-dates-as-a-number-in-the-data-load-editor/m-p/879242#M12192 <HTML><HEAD></HEAD><BODY><P>Hiya</P><P></P><P>awesome ta xxx</P><P></P><P>worked a treat</P><P></P><P>Kind Regards </P><P>Joeybird</P></BODY></HTML> Wed, 06 May 2015 09:09:36 GMT https://community.qlik.com/t5/App-Development/Adding-up-dates-as-a-number-in-the-data-load-editor/m-p/879242#M12192 joeybird 2015-05-06T09:09:36Z