topic Re: How can I calculate the DifferenceIn Months? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777397#M275538 <HTML><HEAD></HEAD><BODY><P>How precise do you need to be? Can you just divide the number of days by 30?</P><P></P><P>(EndDate - StartDate)&nbsp; / 30</P></BODY></HTML> Tue, 13 Jan 2015 00:40:18 GMT rwunderlich 2015-01-13T00:40:18Z How can I calculate the DifferenceIn Months? https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777391#M275532 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a startdate and enddate</P><P>StartDate : 26/06/2013</P><P>EndDate : 02/08/2013</P><P></P><P>When I use the calculator Windows, the result is 1 month and 1 week , in qv it is 2month.</P><P>How can I have the result like the Windows calculator?</P><P></P><P>Thank for your help. </P></BODY></HTML> Mon, 12 Jan 2015 23:21:06 GMT https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777391#M275532 2015-01-12T23:21:06Z Re: How can I calculate the DifferenceIn Months? https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777392#M275533 <HTML><HEAD></HEAD><BODY><P><A _jive_internal="true" href="https://community.qlik.com/message/667406#667406" title="http://community.qlik.com/message/667406#667406">http://community.qlik.com/message/667406#667406</A></P></BODY></HTML> Mon, 12 Jan 2015 23:30:22 GMT https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777392#M275533 nagaiank 2015-01-12T23:30:22Z Re: How can I calculate the DifferenceIn Months? https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777393#M275534 <HTML><HEAD></HEAD><BODY><P>How do you want to use this value in QV? QV does not have an actual week interval. So for you above example, should it be something like "1.25 months" or do you want it to display "1 month and 1 week"?</P><P></P><P>-Rob</P></BODY></HTML> Mon, 12 Jan 2015 23:49:40 GMT https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777393#M275534 rwunderlich 2015-01-12T23:49:40Z Re: How can I calculate the DifferenceIn Months? https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777394#M275535 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?\</P></BODY></HTML> Mon, 12 Jan 2015 23:49:41 GMT https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777394#M275535 2015-01-12T23:49:41Z Re: How can I calculate the DifferenceIn Months? https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777395#M275536 <HTML><HEAD></HEAD><BODY><P>Hi Rob,</P><P></P><P>I would like just month.</P><P></P><P>Ajay your approach is good but if the month the end month possible is 28,30,31 not only 30.</P></BODY></HTML> Mon, 12 Jan 2015 23:57:00 GMT https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777395#M275536 2015-01-12T23:57:00Z Re: How can I calculate the DifferenceIn Months? https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777396#M275537 <HTML><HEAD></HEAD><BODY><P>Rob, yes, I would like 1.25</P></BODY></HTML> Tue, 13 Jan 2015 00:02:44 GMT https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777396#M275537 2015-01-13T00:02:44Z Re: How can I calculate the DifferenceIn Months? https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777397#M275538 <HTML><HEAD></HEAD><BODY><P>How precise do you need to be? Can you just divide the number of days by 30?</P><P></P><P>(EndDate - StartDate)&nbsp; / 30</P></BODY></HTML> Tue, 13 Jan 2015 00:40:18 GMT https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777397#M275538 rwunderlich 2015-01-13T00:40:18Z Re: How can I calculate the DifferenceIn Months? https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777398#M275539 <HTML><HEAD></HEAD><BODY><P>The calculator give me 1.2164383561655998.</P><P>(EndStart - StartDate) / 30 give me 1,2333333333333</P><P></P><P>Is it possible to have the value close to the calculator result or qlikview does an approximation ?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 13 Jan 2015 06:10:34 GMT https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777398#M275539 2015-01-13T06:10:34Z Re: How can I calculate the DifferenceIn Months? https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777399#M275540 <HTML><HEAD></HEAD><BODY><P>What did you type into your calculator to get this value?</P></BODY></HTML> Tue, 13 Jan 2015 06:42:51 GMT https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777399#M275540 MarcoWedel 2015-01-13T06:42:51Z Re: How can I calculate the DifferenceIn Months? https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777400#M275541 <HTML><HEAD></HEAD><BODY><P>I use the calculator Windows (Ctrl+E)</P><P>From : 26/06/2013</P><P>To : 02/08/2013</P></BODY></HTML> Tue, 13 Jan 2015 21:05:11 GMT https://community.qlik.com/t5/QlikView/How-can-I-calculate-the-DifferenceIn-Months/m-p/777400#M275541 2015-01-13T21:05:11Z