https://communities.sas.com/t5/SAS-Enterprise-Guide/Fetching-previous-dates/m-p/864758#M42579 <P>Use the&nbsp;<A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/p10v3sa3i4kfxfn1sovhi5xzxh8n.htm" target="_blank" rel="noopener">INTNX Function</A>&nbsp;with a "qtr" interval and "end" alignment.</P> Fri, 17 Mar 2023 08:44:59 GMT Kurt_Bremser 2023-03-17T08:44:59Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Fetching-previous-dates/m-p/864755#M42578 I have a dataset with quarter end dates such as:<BR />Date<BR />31.03.2022<BR />30.06.2022<BR />30.09.2022<BR />31.12.2022<BR /><BR />Using one date i need to fetch the data with the previous date. (Eg: fetch data with 30.09.2022 using date 31.12.2022)How can i do this. Please provide a solution. Fri, 17 Mar 2023 07:45:08 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Fetching-previous-dates/m-p/864755#M42578 hasnasherin 2023-03-17T07:45:08Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Fetching-previous-dates/m-p/864758#M42579 <P>Use the&nbsp;<A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/p10v3sa3i4kfxfn1sovhi5xzxh8n.htm" target="_blank" rel="noopener">INTNX Function</A>&nbsp;with a "qtr" interval and "end" alignment.</P> Fri, 17 Mar 2023 08:44:59 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Fetching-previous-dates/m-p/864758#M42579 Kurt_Bremser 2023-03-17T08:44:59Z