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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ayden
Contributor III
Contributor III

Month between two date fields

hello how could i get the difference in months  between date fields i.e datefiel1 and datedfield2.

Load

datefield1,

datefield2,

datefield1 - datefiled2 as monthdiffrence

from xyz;

 

Thanks people 

 

1 Solution

Accepted Solutions
abhijitnalekar
Specialist II
Specialist II

Hi @Ayden,

 

Please go through with the below links

https://community.qlik.com/t5/QlikView-App-Dev/Difference-in-Months-between-2-dates/m-p/1760255

 

https://community.qlik.com/t5/New-to-Qlik-Sense/Calculate-the-difference-of-months-between-dates/td-...

 

 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

1 Reply
abhijitnalekar
Specialist II
Specialist II

Hi @Ayden,

 

Please go through with the below links

https://community.qlik.com/t5/QlikView-App-Dev/Difference-in-Months-between-2-dates/m-p/1760255

 

https://community.qlik.com/t5/New-to-Qlik-Sense/Calculate-the-difference-of-months-between-dates/td-...

 

 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!