Calculating Days

[k5kowboy]

I need to calculate the total number of days that I have something in inventory. I can't find any help with this, so maybe I can get some insight here.

If I place an item in inventory on Jun 30th and remove it from inventory on July 4th, how can I get access to calculate that as a total of 5 days?

 

[FoFa]

use DATEDIFF function specifing days for the return
DATEDIFF("d",startdate,enddate)
If in code and assign it to a variable
intvar=DATEDIFF("d",startdate,enddate)