topic Confusion with InQuarter function in QlikView https://community.qlik.com/t5/QlikView/Confusion-with-InQuarter-function/m-p/219865#M72838 <HTML><HEAD></HEAD><BODY><P>Just reverse your dates: =InQuarter('2009-09-30','2009-12-31',-1)</P><P>Regards,</P></BODY></HTML> Thu, 21 Jan 2010 20:55:38 GMT vgutkovsky 2010-01-21T20:55:38Z Confusion with InQuarter function https://community.qlik.com/t5/QlikView/Confusion-with-InQuarter-function/m-p/219864#M72837 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am trying to using the InQuarter function to detect a date which is in the previous quarter. So using a basedate of 12/31/2009 I would like to recognise 09/30/2009 as date in the previous quarter. Using the formula below, this is not happening. Would anyone know why this is the case?</P><P>Thanks for your help</P><P>=<B>InQuarter</B>('2009-12-31','2009-09-30',-1)</P></BODY></HTML> Thu, 21 Jan 2010 20:48:54 GMT https://community.qlik.com/t5/QlikView/Confusion-with-InQuarter-function/m-p/219864#M72837 2010-01-21T20:48:54Z Confusion with InQuarter function https://community.qlik.com/t5/QlikView/Confusion-with-InQuarter-function/m-p/219865#M72838 <HTML><HEAD></HEAD><BODY><P>Just reverse your dates: =InQuarter('2009-09-30','2009-12-31',-1)</P><P>Regards,</P></BODY></HTML> Thu, 21 Jan 2010 20:55:38 GMT https://community.qlik.com/t5/QlikView/Confusion-with-InQuarter-function/m-p/219865#M72838 vgutkovsky 2010-01-21T20:55:38Z Confusion with InQuarter function https://community.qlik.com/t5/QlikView/Confusion-with-InQuarter-function/m-p/219866#M72839 <HTML><HEAD></HEAD><BODY><P>Thanks Vlad. It looks I misunderstood the function.</P></BODY></HTML> Thu, 21 Jan 2010 21:24:58 GMT https://community.qlik.com/t5/QlikView/Confusion-with-InQuarter-function/m-p/219866#M72839 2010-01-21T21:24:58Z