Adding up dates as a number in the data load editor

[joeybird]

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

[Anonymous · Accepted solution]

Remove "if":

sum(DateOrderCompleted - DateOrderReceived) as [TotalNumberOfDays],

[MK_QSL]

Interval(DateOrderCompleted - DateOrderReceived,'DD') as TotalNumberOfDays

[nico_ilog]

Hi Joanna,

Why not simply:

Date((DateOrderCompleted)) - Date((DateOrderReceived)) as TotalNumberOfDays

Lemme know.

Regards,

N

[joeybird]

Hiya

awesome ta xxx

worked a treat

Kind Regards

Joeybird