DATE CALCULATIONS

[Candyman_mm]

Is there any way I can create a formula that calculates and returns the value of the difference between the "current date" and a prior date in a table. So that whenever I enter the prior date in the row, another filed will display the result of (current date) - (prior date) = [LongInteger], described as item age; which changes value per day since current day will remain current?

 

[Rich]

Look up the DateDiff function