Difference between dates in months and years

[Aladdin777]

Trying to workout difference between date A and date B. 

For example: Date A - 15 Jan 2020 and Date B - 18 Apr 2021 should give me 1.25 years

Thank you in advance!

[johnt75 · Accepted solution]

DATEDIFF( DATE(2020, 1, 15), DATE(2021, 4, 18), MONTH) / 12