https://community.qlik.com/t5/QlikView/figures-in-month/m-p/1781999#M1227977 <P>refer to below expression.. update as required</P><LI-CODE lang="php">( num(Year(today())) - num(Year(pdate)) ) * 12 + num(Month(today())) - num(Month(pdate))</LI-CODE><P>Where &lt;pdate&gt; is your column and Month range (pdate,today]</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Monthback Cal.png" style="width: 955px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/48915i6C2499B9806B643A/image-size/large?v=v2&amp;px=999" role="button" title="Monthback Cal.png" alt="Monthback Cal.png" /></span></P><P>&nbsp;</P><P>Hope this helps!</P> Thu, 11 Feb 2021 14:09:07 GMT PradeepK 2021-02-11T14:09:07Z https://community.qlik.com/t5/QlikView/figures-in-month/m-p/1781991#M1227971 <P>hi&nbsp;</P><P>&nbsp;</P><P>i have a column where is date_of_purchase.</P><P>i want to minus that date into today date and want to get months.. means how many months utilize till today date..</P><P>like if date_of_purchase is 03-07-2016 ... and today is 11 feb 2021. so means total 54 months is utilized if I count manually.</P><P>how I get that?</P><P>&nbsp;</P> Mon, 26 Jan 2026 21:26:37 GMT https://community.qlik.com/t5/QlikView/figures-in-month/m-p/1781991#M1227971 capriconuser 2026-01-26T21:26:37Z https://community.qlik.com/t5/QlikView/figures-in-month/m-p/1781995#M1227975 <P>try this:</P><P><A href="https://community.qlik.com/t5/QlikView-App-Dev/How-Do-I-Get-the-Number-of-Months-Between-Two-Dates/td-p/296928" target="_blank">Solved: How Do I Get the Number of Months Between Two Date... - Qlik Community - 296928</A></P><P>&nbsp;</P> Thu, 11 Feb 2021 14:03:30 GMT https://community.qlik.com/t5/QlikView/figures-in-month/m-p/1781995#M1227975 edwin 2021-02-11T14:03:30Z https://community.qlik.com/t5/QlikView/figures-in-month/m-p/1781999#M1227977 <P>refer to below expression.. update as required</P><LI-CODE lang="php">( num(Year(today())) - num(Year(pdate)) ) * 12 + num(Month(today())) - num(Month(pdate))</LI-CODE><P>Where &lt;pdate&gt; is your column and Month range (pdate,today]</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Monthback Cal.png" style="width: 955px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/48915i6C2499B9806B643A/image-size/large?v=v2&amp;px=999" role="button" title="Monthback Cal.png" alt="Monthback Cal.png" /></span></P><P>&nbsp;</P><P>Hope this helps!</P> Thu, 11 Feb 2021 14:09:07 GMT https://community.qlik.com/t5/QlikView/figures-in-month/m-p/1781999#M1227977 PradeepK 2021-02-11T14:09:07Z