topic difference in dates in QlikView

difference in dates

raghavsurya — Thu, 07 Oct 2010 09:24:32 GMT

Hi All,

I have two dates loaded into the tables PLDate and RDate. I wanted to calculate the difference in days in a straight table chart.

PLDate is the order creation date

RDate is the Goods received date.

We need to calculate the difference in terms of days between the order date and receipt date. Can anybody help me with the expression to get the difference between these two dates.

Regards,

Raghav

difference in dates

Thu, 07 Oct 2010 09:48:33 GMT

You can try interval(RDate-PLDate,'dd') to get the number of days between both.

Rgds,

Sébastien

difference in dates

raghavsurya — Thu, 07 Oct 2010 11:44:30 GMT

Hi Sebastien,

Thanks for the your valuable inputs.

Regards,

Raghav