Difference Between two dates

royalapps — Fri, 15 Nov 2024 23:32:48 GMT

How to calculate difference between two dates

I have two date fileds

First record

One is order expected date 22 may 2020

Second is order delivered date 25 may 2020

The out is minus 3 days

Second record

One is order expected date 22 may 2020

Second is order delivered date 20 may 2020

Here's the difference is 2 days

So here I want difference between these two dates

Based on these difference days I want to create calucalte dimension

Minus three days order delayed

If 2 days order delivered

Please help me on this

Thanks

Re: Difference Between two dates

MayilVahanan — Mon, 30 Nov 2020 02:18:21 GMT

Try like below

Load *, If(DayDiff < 0, 'order delayed', 'order delivered') as Status;

Load * , interval([order expected date] -[order delivered date], 'D') as DayDiff from yoursource;