topic Re: Calculating number of Quarters between dates in QlikView https://community.qlik.com/t5/QlikView/Calculating-number-of-Quarters-between-dates/m-p/261174#M98472 <HTML><HEAD></HEAD><BODY><P>I think this?</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">year(enddate)*4 + ceil(month(enddate)/3) - year(startdate)*4 - ceil(month(startdate)/3)</SPAN></P><P></P><P>That's not normally what I think of when I think "how many quarters are in this range", though.&nbsp; For instance, I believe that datediff(q, Jan 1 2011, Dec 31 2011) returns 3, even though the date range is a full four quarters.&nbsp; That's because we only cross 3 quarter boundaries, and datediff is counting boundary crossings, right?</P></BODY></HTML> Tue, 09 Aug 2011 21:34:05 GMT johnw 2011-08-09T21:34:05Z Calculating number of Quarters between dates https://community.qlik.com/t5/QlikView/Calculating-number-of-Quarters-between-dates/m-p/261173#M98471 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I'm trying to find a way to calculate the number of quarters between a start date and an end date. I believe this is straightforward to do with a DateDiff function, but I cannot see anything similar in QlikView. Any help greatly appreciated.</P></BODY></HTML> Tue, 09 Aug 2011 20:55:26 GMT https://community.qlik.com/t5/QlikView/Calculating-number-of-Quarters-between-dates/m-p/261173#M98471 2011-08-09T20:55:26Z Re: Calculating number of Quarters between dates https://community.qlik.com/t5/QlikView/Calculating-number-of-Quarters-between-dates/m-p/261174#M98472 <HTML><HEAD></HEAD><BODY><P>I think this?</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">year(enddate)*4 + ceil(month(enddate)/3) - year(startdate)*4 - ceil(month(startdate)/3)</SPAN></P><P></P><P>That's not normally what I think of when I think "how many quarters are in this range", though.&nbsp; For instance, I believe that datediff(q, Jan 1 2011, Dec 31 2011) returns 3, even though the date range is a full four quarters.&nbsp; That's because we only cross 3 quarter boundaries, and datediff is counting boundary crossings, right?</P></BODY></HTML> Tue, 09 Aug 2011 21:34:05 GMT https://community.qlik.com/t5/QlikView/Calculating-number-of-Quarters-between-dates/m-p/261174#M98472 johnw 2011-08-09T21:34:05Z Re: Calculating number of Quarters between dates https://community.qlik.com/t5/QlikView/Calculating-number-of-Quarters-between-dates/m-p/261175#M98473 <HTML><HEAD></HEAD><BODY><P> Many thanks John - this is exactly what I required.</P></BODY></HTML> Wed, 10 Aug 2011 08:21:39 GMT https://community.qlik.com/t5/QlikView/Calculating-number-of-Quarters-between-dates/m-p/261175#M98473 2011-08-10T08:21:39Z