How to determine the number of years between two dates?

Question:

Answer:

Use calculated field and Datediff function. Here are some examples:

Number of years between two dates:

Datediff(year,datefield1,datefield2)

Number of months between two dates:

Datediff(month,datefield1,datefield2)

Number of days between two dates:

Datediff(day,datefield1,datefield2)