topic How Do I Get the Number of Months Between Two Dates? in QlikView https://community.qlik.com/t5/QlikView/How-Do-I-Get-the-Number-of-Months-Between-Two-Dates/m-p/52858#M458385 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I am still lost in number of months between dates expression.</P><P>Being New to QV &amp; Scripting but is been like thrown into the deep end.</P><P>this question was raised by @<A _jive_internal="true" class="jiveTT-hover-user jive-username-link" data-avatarid="3585" data-externalid="" data-presence="null" data-userid="47330" data-username="jonathanshaltz" href="https://community.qlik.com/people/jonathanshaltz"><STRONG style="color: #3778c7;">Jonathan Shaltz</STRONG></A> earlier</P><P></P><P>&nbsp; Data set i have:</P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD class="xl67" height="32" style="border: 0px solid black; border-image: none;" width="103">Start Date</TD><TD class="xl67" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="103">Completed Date</TD></TR><TR><TD class="xl68" height="19" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">21-Mar-1997</TD><TD class="xl68" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">31-Dec-2030</TD></TR><TR><TD class="xl68" height="19" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">01-Jun-2010</TD><TD class="xl68" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">31-Dec-2030</TD></TR><TR><TD class="xl68" height="19" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">10-May-2013</TD><TD class="xl68" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">31-Dec-2030</TD></TR></TBODY></TABLE><P></P><OL><LI>find the number of months between the dates</LI><LI><SPAN style="font-size: 13.33px;">find the number of Years between the dates</SPAN></LI><LI><SPAN style="font-size: 13.33px;">Do not load/(drop) data below certain year stamp</SPAN></LI></OL><P><SPAN style="font-size: 13.33px;"><IMG alt="How Do I Get the Number of Months Between Two Dates.jpg" class="jive-image image-1" src="/legacyfs/online/196804_How Do I Get the Number of Months Between Two Dates.jpg" style="width: 620px; height: 218px;" /></SPAN></P><P></P><P><SPAN style="font-size: 13.33px;">@<A _jive_internal="true" class="jiveTT-hover-user jive-username-link" data-avatarid="3585" data-externalid="" data-presence="null" data-userid="47330" data-username="jonathanshaltz" href="https://community.qlik.com/people/jonathanshaltz"><STRONG style="color: #3778c7;">Jonathan Shaltz</STRONG></A></SPAN></P></BODY></HTML> Tue, 20 Mar 2018 06:39:04 GMT Anonymous 2018-03-20T06:39:04Z How Do I Get the Number of Months Between Two Dates? https://community.qlik.com/t5/QlikView/How-Do-I-Get-the-Number-of-Months-Between-Two-Dates/m-p/52858#M458385 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I am still lost in number of months between dates expression.</P><P>Being New to QV &amp; Scripting but is been like thrown into the deep end.</P><P>this question was raised by @<A _jive_internal="true" class="jiveTT-hover-user jive-username-link" data-avatarid="3585" data-externalid="" data-presence="null" data-userid="47330" data-username="jonathanshaltz" href="https://community.qlik.com/people/jonathanshaltz"><STRONG style="color: #3778c7;">Jonathan Shaltz</STRONG></A> earlier</P><P></P><P>&nbsp; Data set i have:</P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD class="xl67" height="32" style="border: 0px solid black; border-image: none;" width="103">Start Date</TD><TD class="xl67" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="103">Completed Date</TD></TR><TR><TD class="xl68" height="19" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">21-Mar-1997</TD><TD class="xl68" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">31-Dec-2030</TD></TR><TR><TD class="xl68" height="19" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">01-Jun-2010</TD><TD class="xl68" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">31-Dec-2030</TD></TR><TR><TD class="xl68" height="19" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">10-May-2013</TD><TD class="xl68" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">31-Dec-2030</TD></TR></TBODY></TABLE><P></P><OL><LI>find the number of months between the dates</LI><LI><SPAN style="font-size: 13.33px;">find the number of Years between the dates</SPAN></LI><LI><SPAN style="font-size: 13.33px;">Do not load/(drop) data below certain year stamp</SPAN></LI></OL><P><SPAN style="font-size: 13.33px;"><IMG alt="How Do I Get the Number of Months Between Two Dates.jpg" class="jive-image image-1" src="/legacyfs/online/196804_How Do I Get the Number of Months Between Two Dates.jpg" style="width: 620px; height: 218px;" /></SPAN></P><P></P><P><SPAN style="font-size: 13.33px;">@<A _jive_internal="true" class="jiveTT-hover-user jive-username-link" data-avatarid="3585" data-externalid="" data-presence="null" data-userid="47330" data-username="jonathanshaltz" href="https://community.qlik.com/people/jonathanshaltz"><STRONG style="color: #3778c7;">Jonathan Shaltz</STRONG></A></SPAN></P></BODY></HTML> Tue, 20 Mar 2018 06:39:04 GMT https://community.qlik.com/t5/QlikView/How-Do-I-Get-the-Number-of-Months-Between-Two-Dates/m-p/52858#M458385 Anonymous 2018-03-20T06:39:04Z Re: How Do I Get the Number of Months Between Two Dates? https://community.qlik.com/t5/QlikView/How-Do-I-Get-the-Number-of-Months-Between-Two-Dates/m-p/52859#M458386 <HTML><HEAD></HEAD><BODY><P>Hi Tony</P><P></P><P>Try replacing your highlighted line with the following</P><P></P><P>((Year([Completed Date])*12) + Month([Completed Date])) - ((Year([Start Date])*12) + Month([Start Date])) As MonthDiff,</P></BODY></HTML> Tue, 20 Mar 2018 16:10:05 GMT https://community.qlik.com/t5/QlikView/How-Do-I-Get-the-Number-of-Months-Between-Two-Dates/m-p/52859#M458386 atoz1158 2018-03-20T16:10:05Z Re: How Do I Get the Number of Months Between Two Dates? https://community.qlik.com/t5/QlikView/How-Do-I-Get-the-Number-of-Months-Between-Two-Dates/m-p/52860#M458387 <HTML><HEAD></HEAD><BODY><P>Hi Adrian,</P><P>thanks so much</P><P></P><P>Tony</P></BODY></HTML> Fri, 01 Jun 2018 18:11:29 GMT https://community.qlik.com/t5/QlikView/How-Do-I-Get-the-Number-of-Months-Between-Two-Dates/m-p/52860#M458387 Anonymous 2018-06-01T18:11:29Z