Easy part - I would like to subtact two dates from each other to see how many days have elapsed between the two dates.
Hard part - these two dates belong to the same field. DateDiff seems to require two different fields to subtract.
Example:
Case # Code Date 3
FSP1 A105 4/16/2012
FSP1 A110 4/22/2012
How can I subtract the 4/16/2012 value from the 4/22/2012 value?
Edited by KMendels - 05 Jun 2012 at 9:58am