difference in dates

[raghavsurya]

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

[#2]

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

Rgds,

Sébastien

[raghavsurya]

Hi Sebastien,

Thanks for the your valuable inputs.

Regards,

Raghav