https://community.qlik.com/t5/QlikView/Create-new-field-Max-date-before-current-quarter-in-Load/m-p/1571780#M598181 <P>How to Create new field - <STRONG>Max date before current quarter</STRONG></P><P>Q1 Nov-Jan<BR />Q2 Feb-Apr (Current Quarter)<BR />Q3 May-Jul<BR />Q4 Aug-Oct</P><P>SQL<BR />Select Product_ID,<BR />Max(Date(Sales_Date)) as Max_Sales_date<BR />From Table1 A<BR />where Sales_Date='01/31/2019'&nbsp; <EM><STRONG>(Not Hardcoded)</STRONG></EM><BR />Group by Product_ID</P> Mon, 22 Apr 2019 19:04:01 GMT karan_kn 2019-04-22T19:04:01Z https://community.qlik.com/t5/QlikView/Create-new-field-Max-date-before-current-quarter-in-Load/m-p/1571780#M598181 <P>How to Create new field - <STRONG>Max date before current quarter</STRONG></P><P>Q1 Nov-Jan<BR />Q2 Feb-Apr (Current Quarter)<BR />Q3 May-Jul<BR />Q4 Aug-Oct</P><P>SQL<BR />Select Product_ID,<BR />Max(Date(Sales_Date)) as Max_Sales_date<BR />From Table1 A<BR />where Sales_Date='01/31/2019'&nbsp; <EM><STRONG>(Not Hardcoded)</STRONG></EM><BR />Group by Product_ID</P> Mon, 22 Apr 2019 19:04:01 GMT https://community.qlik.com/t5/QlikView/Create-new-field-Max-date-before-current-quarter-in-Load/m-p/1571780#M598181 karan_kn 2019-04-22T19:04:01Z