That would be:
Datediff('year', [Date Acquired], TODAY())
Hi Jeff, looks like you are looking for a datediff calculation.
1. Go to Analysis>Create Calculated field
2. Enter the calculation: DATEDIFF('day',[Date Acquired],TODAY())
3. A numeric calculated field will be created that will show the age of your medical equipment at the day level.
1 of 1 people found this helpful
This worked. thank you.