Kaleb Try using the function ADDYR
SET VAR bdate DATE = 3/1/2016 SET VAR sdate DATE = 3/31/2016 SET VAR bdate2 DATE = (ADDYR(.bdate,-1)) SET VAR sdate2 DATE = (ADDYR(.sdate, -1)) Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Kaleb Wade Sent: Saturday, March 5, 2016 3:52 PM To: [email protected] Subject: [RBASE-L] - Help with RDATE function I am trying to use the following for a user to provide a beginning date (bdate) and ending date (sdate) and a variable to be set for the same month and day, but for the prior year. I have exhausted every possibility I can come up with. Any help would be very much appreciated. My settings are: Date format: mm/dd/yyyy Date sequence: mm/dd/yy Using R:BASE X for Windows SET VAR bdate DATE SET VAR sdate DATE SET VAR bdate2 DATE SET VAR sdate2 DATE FILLIN bdate USING 'ENTER THE BEGINNING DATE :' FILLIN sdate USING 'ENTER THE ENDING DATE :' SET VAR bdate2 = (RDATE((IMON(bdate)),(IDAY(bdate)),(IYR(bdate))-1)) SET VAR sdate2 = (RDATE((IMON(sdate)),(IDAY(sdate)),(IYR(sdate))-1)) Kaleb Wade [email protected] <mailto:[email protected]>
