Ok. Thank you for the info and checking it in your system. This at least narrows it down!
On Saturday, March 5, 2016, Jim Belisle <[email protected]> wrote: > I have both date settings the same MM/DD/YYYY and the below code works > when I use the set var command. > May be the date input settings. > > set var vdatea date = 03/01/2016 > set var vdateb date = 03/05/2016 > > SET VAR bdate2 = (RDATE((IMON(.vdateb)),(IDAY(.vdateb)),(IYR(.vdateb))-1)) > This gives me 03/05/2015 > SET VAR sdate2 = (RDATE((IMON(.vdatea)),(IDAY(.vdatea)),(IYR(.vdatea))-1)) > This gives me 03/01/2015 > > > James Belisle > > Making Information Systems People Friendly Since 1990 > [cid:[email protected]] > > From: [email protected] <javascript:;> [mailto:[email protected] > <javascript:;>] On Behalf Of Kaleb Wade > Sent: Saturday, March 05, 2016 3:33 PM > To: Jim Belisle > Subject: [RBASE-L] - RE: Help with RDATE function > > I tried this already and also using IYR4 instead of IYR with and without > the dots infront of the variables. No combination has worked thus far. I'm > thinking it may a misplaced parentheses in the year section. > > On Saturday, March 5, 2016, Jim Belisle <[email protected] <javascript:;> > <mailto:[email protected] <javascript:;>>> wrote: > Try putting a dot in front of the date variable in your equation. > SET VAR bdate2 = (RDATE((IMON(.bdate)),(IDAY(.bdate)),(IYR(.bdate))-1)) > SET VAR sdate2 = (RDATE((IMON(.sdate)),(IDAY(.sdate)),(IYR(.sdate))-1)) > > James Belisle > > Making Information Systems People Friendly Since 1990 > [cid:[email protected]] > > From: [email protected] <javascript:;><javascript:;> [mailto: > [email protected] <javascript:;><javascript:;>] On Behalf Of Kaleb Wade > Sent: Saturday, March 05, 2016 2:52 PM > To: Jim Belisle > 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] <javascript:;><javascript:;><mailto: > [email protected] <javascript:;><javascript:;>> > > > -- > Sent from Gmail Mobile > -- Sent from Gmail Mobile
