Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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.