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

      Hiya

       

      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

       

      joeybird