topic Re: Calculate difference in months between two dates in QlikView https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16492#M2717 <HTML><HEAD></HEAD><BODY><P>Isn't there an easier way?</P></BODY></HTML> Wed, 25 Apr 2018 12:55:34 GMT sujit_nath 2018-04-25T12:55:34Z Calculate difference in months between two dates https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16487#M2712 <HTML><HEAD></HEAD><BODY><P>I have 2 columns in format MM/DD/YYYY</P><P>I need to calculate the difference in months between 2 dates.</P><P>Ex: 04/25/2018&nbsp; -&nbsp; 02/11/2016</P><P>and so on...</P></BODY></HTML> Wed, 25 Apr 2018 12:48:04 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16487#M2712 sujit_nath 2018-04-25T12:48:04Z Re: Calculate difference in months between two dates https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16488#M2713 <HTML><HEAD></HEAD><BODY><P>Look at Rob's response here</P><P><A href="https://community.qlik.com/thread/47580">How Do I Get the Number of Months Between Two Dates?</A></P></BODY></HTML> Wed, 25 Apr 2018 12:50:11 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16488#M2713 sunny_talwar 2018-04-25T12:50:11Z Re: Calculate difference in months between two dates https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16489#M2714 <HTML><HEAD></HEAD><BODY><P>Something like this</P><P></P><P><STRONG>=(Year(MakeDate(2018, 4, 25)) * 12 + Month(MakeDate(2018, 4, 25))) - (Year(MakeDate(2016, 2, 11)) * 12 + Month(MakeDate(2016, 2, 11)))</STRONG></P></BODY></HTML> Wed, 25 Apr 2018 12:51:26 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16489#M2714 sunny_talwar 2018-04-25T12:51:26Z Re: Calculate difference in months between two dates https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16490#M2715 <HTML><HEAD></HEAD><BODY><P>I'm doing that in backend</P></BODY></HTML> Wed, 25 Apr 2018 12:53:21 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16490#M2715 sujit_nath 2018-04-25T12:53:21Z Re: Calculate difference in months between two dates https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16491#M2716 <HTML><HEAD></HEAD><BODY><P>This applies on the back end or front end</P></BODY></HTML> Wed, 25 Apr 2018 12:54:00 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16491#M2716 sunny_talwar 2018-04-25T12:54:00Z Re: Calculate difference in months between two dates https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16492#M2717 <HTML><HEAD></HEAD><BODY><P>Isn't there an easier way?</P></BODY></HTML> Wed, 25 Apr 2018 12:55:34 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16492#M2717 sujit_nath 2018-04-25T12:55:34Z Re: Calculate difference in months between two dates https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16493#M2718 <HTML><HEAD></HEAD><BODY><P>What is so difficult about the above syntax?</P></BODY></HTML> Wed, 25 Apr 2018 13:01:41 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16493#M2718 sunny_talwar 2018-04-25T13:01:41Z Re: Calculate difference in months between two dates https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16494#M2719 <HTML><HEAD></HEAD><BODY><P>Does this take into consideration leap years?</P></BODY></HTML> Wed, 25 Apr 2018 13:05:20 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16494#M2719 sujit_nath 2018-04-25T13:05:20Z Re: Calculate difference in months between two dates https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16495#M2720 <HTML><HEAD></HEAD><BODY><P>Are we talking about Month difference or Day Difference? How does Day play any role when determining the difference in Month... I am not sure I understand... from the two dates that you provided... what is your expected output?</P></BODY></HTML> Wed, 25 Apr 2018 13:07:04 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16495#M2720 sunny_talwar 2018-04-25T13:07:04Z Re: Calculate difference in months between two dates https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16496#M2721 <HTML><HEAD></HEAD><BODY><P>I want that if it is more than 12 months it should put something after decimal, ie. 12.xyz..</P><P>If it's less than 12 as well, it should show in decimals, ex: a difference of 2 months 15 days should show as 2.5 etc.</P></BODY></HTML> Wed, 25 Apr 2018 13:12:35 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16496#M2721 sujit_nath 2018-04-25T13:12:35Z Re: Calculate difference in months between two dates https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16497#M2722 <HTML><HEAD></HEAD><BODY><P>May be use this where 30.4 gives a good approximation for the number of days in a month on average.</P><P></P><P><STRONG>=(MakeDate(2018, 4, 25) - MakeDate(2016, 2, 11))/30.4</STRONG></P><P></P><P>This gives 26.44</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/200778_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Apr 2018 13:15:46 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-in-months-between-two-dates/m-p/16497#M2722 sunny_talwar 2018-04-25T13:15:46Z