Forum Discussion
Difference between dates in months and years
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!
DATEDIFF( DATE(2020, 1, 15), DATE(2021, 4, 18), MONTH) / 12
1 Reply
johnt75Super User
DATEDIFF( DATE(2020, 1, 15), DATE(2021, 4, 18), MONTH) / 12