Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlik_aparna
Partner - Contributor III
Partner - Contributor III

Difference between year along with months

Hi Everyone,

I want to find the difference between dates along with the months. Example Date1 is 2032-01-15 and Date 2 is 2021-02-22 the expected difference is 10years and 11 months so it should appear as 10.11. Using Year(Date1) or Month(Date1) is not giving expected answers. Any help on this?

Labels (2)
1 Reply
rbartley
Specialist II
Specialist II

It depends on your data structure.  Do you mean you have 2 fields and you want to find the difference or that you want the difference between one date and another in the same field.  If you also post your app, it will be easier to answer.