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.
sum(DateOrderCompleted - DateOrderReceived) as [TotalNumberOfDays],
awesome ta xxx
worked a treat
Interval(DateOrderCompleted - DateOrderReceived,'DD') as TotalNumberOfDays
Why not simply:
Date((DateOrderCompleted)) - Date((DateOrderReceived)) as TotalNumberOfDays
Retrieving data ...