Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Remove "if":
sum(DateOrderCompleted - DateOrderReceived) as [TotalNumberOfDays],
Remove "if":
sum(DateOrderCompleted - DateOrderReceived) as [TotalNumberOfDays],
Interval(DateOrderCompleted - DateOrderReceived,'DD') as TotalNumberOfDays
Hi Joanna,
Why not simply:
Date((DateOrderCompleted)) - Date((DateOrderReceived)) as TotalNumberOfDays
Lemme know.
Regards,
N
Hiya
awesome ta xxx
worked a treat
Kind Regards
Joeybird