4 Replies Latest reply: May 6, 2015 5:09 AM by Joanna Seldon RSS

    Adding up dates as a number in the data load editor

    Joanna Seldon



      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


      sum(if(DateOrderCompleted) - (DateOrderReceived) as [TotalNumberOfDays],


      I cant seem to crack it.


      please help


      Kind regards