topic Difference between two dates in Hours,Days, Months and years in QlikView

Difference between two dates in Hours,Days, Months and years

Mon, 29 Oct 2012 20:54:23 GMT

Experts,

I have a requirement to find the difference between two dates in Hours,Days, Months and years.

Fop example : order_date 10/01/2012 , Ship_Date 10/12/2012. What i would like to do is Ship_Date - order_date = 12 days

Is there any way I could do this in expresion?

thanks in advance,

Aji Paul.

MayilVahanan — Mon, 29 Oct 2012 21:01:32 GMT

Try like this

=Interval(ShipDate-OrderDate,'d hhmm:ss') for day difference

For Year:

=Year(ShipDate) - Year(OrderDate)

Hope it helps

arjunkrishnan — Mon, 07 Apr 2014 06:43:18 GMT

Hai Aji,

Use this Code It's Work Fine

Floor(Interval(order_date-Ship_Date,'DD')) -> For Days

Floor(Interval(order_date-Ship_Date,'D HH:MM:SS'))->For Days With TimeStamp

Mon, 07 Apr 2014 07:05:29 GMT

Like this

=Interval(Date(ShipDate,'DD/MM/YYYY hh:mm:ss')-Date(OrderDate,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss')

Ex: These are your

order_date 10/01/2012 and

Ship_Date 10/12/2012

Result as per the given expression : 11/00/0000 00:00:00