https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Dates-Times-and-Interval-Functions/m-p/30218#M4101 When trying to use the interval function (intnx) to calculate the dates for the Monday of the previous 4 weeks based upon todays date, I am being returned a spureous date for week3. <BR /> <BR /> Select Data:<BR /> <BR /> Today = today()<BR /> Week1 = INTNX('week1.2',today(),0)<BR /> Week2 = INTNX('week2.2',today(),0)<BR /> Week3 = INTNX('week3.2',today(),0)<BR /> Week4 = INTNX('week4.2',today(),0)<BR /> <BR /> Output:<BR /> <BR /> Today = 02/06/2010 <BR /> Week1 = 31/05/2010 <BR /> Week2 = 24/05/2010 <BR /> Week3 = 31/05/2010 (should be 17/05/2010)<BR /> Week4 = 10/05/2010<BR /> <BR /> Any ideas?<BR /> <BR /> Regards<BR /> <BR /> Len Harbottle Wed, 02 Jun 2010 11:21:15 GMT LenHarbottle 2010-06-02T11:21:15Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Dates-Times-and-Interval-Functions/m-p/30218#M4101 When trying to use the interval function (intnx) to calculate the dates for the Monday of the previous 4 weeks based upon todays date, I am being returned a spureous date for week3. <BR /> <BR /> Select Data:<BR /> <BR /> Today = today()<BR /> Week1 = INTNX('week1.2',today(),0)<BR /> Week2 = INTNX('week2.2',today(),0)<BR /> Week3 = INTNX('week3.2',today(),0)<BR /> Week4 = INTNX('week4.2',today(),0)<BR /> <BR /> Output:<BR /> <BR /> Today = 02/06/2010 <BR /> Week1 = 31/05/2010 <BR /> Week2 = 24/05/2010 <BR /> Week3 = 31/05/2010 (should be 17/05/2010)<BR /> Week4 = 10/05/2010<BR /> <BR /> Any ideas?<BR /> <BR /> Regards<BR /> <BR /> Len Harbottle Wed, 02 Jun 2010 11:21:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Dates-Times-and-Interval-Functions/m-p/30218#M4101 LenHarbottle 2010-06-02T11:21:15Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Dates-Times-and-Interval-Functions/m-p/30219#M4102 Suggest you review the SAS INTNX DOC on how you want to use the INTNX function with the WEEK value and a "multiple" *AND* and a "shift-index". Possibly you want to be incrementing (actually it would be decrementing) argument #3 instead for a prior period start date? Maybe it would be helpful to explain what you are trying to accomplish with the SAS expressions?<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Thu, 03 Jun 2010 02:05:42 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Dates-Times-and-Interval-Functions/m-p/30219#M4102 sbb 2010-06-03T02:05:42Z