Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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!