topic Re: difference b/w dates in QlikView https://community.qlik.com/t5/QlikView/difference-b-w-dates/m-p/752614#M1022553 <HTML><HEAD></HEAD><BODY><P>use year and month functions</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Month(Date2)-Month(Date1)+(Year(Date2)-Year(Date1))*12 </SPAN></P></BODY></HTML> Thu, 19 Mar 2015 14:44:23 GMT maxgro 2015-03-19T14:44:23Z difference b/w dates https://community.qlik.com/t5/QlikView/difference-b-w-dates/m-p/752613#M1022552 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have 2 dates date 1=18/3/2015&nbsp;&nbsp; and date 2 =18/3/2013</P><P></P><P>Now I want how many months difference between these 2 dates by using qlikview function?</P></BODY></HTML> Thu, 19 Mar 2015 14:29:34 GMT https://community.qlik.com/t5/QlikView/difference-b-w-dates/m-p/752613#M1022552 prabhas277 2015-03-19T14:29:34Z Re: difference b/w dates https://community.qlik.com/t5/QlikView/difference-b-w-dates/m-p/752614#M1022553 <HTML><HEAD></HEAD><BODY><P>use year and month functions</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Month(Date2)-Month(Date1)+(Year(Date2)-Year(Date1))*12 </SPAN></P></BODY></HTML> Thu, 19 Mar 2015 14:44:23 GMT https://community.qlik.com/t5/QlikView/difference-b-w-dates/m-p/752614#M1022553 maxgro 2015-03-19T14:44:23Z Re: difference b/w dates https://community.qlik.com/t5/QlikView/difference-b-w-dates/m-p/752615#M1022554 <HTML><HEAD></HEAD><BODY><P>Hi <STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/prabhas277">prabhas277</A></STRONG>,</P><P>Check this out &amp; try</P><P></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> Thu, 19 Mar 2015 14:45:32 GMT https://community.qlik.com/t5/QlikView/difference-b-w-dates/m-p/752615#M1022554 sibideepak 2015-03-19T14:45:32Z