Also note, with SEQUENCE set to mmddyy, RBASE will still accept 4 digit years correctly. It just interpets 2 digit year input. I keep it that way all the time.
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce Chitiea Sent: Friday, March 11, 2011 4:15 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: R:Base 5.5 CSV Import Date Issue Karen and Bill: Thank you for your clarity. You've provided a perfect tutorial on the issue. Cheers, bruce chitiea safesectors inc. > -------- Original Message -------- > Subject: [RBASE-L] - Re: R:Base 5.5 CSV Import Date Issue > From: Bill Downall <[email protected]> > Date: Fri, March 11, 2011 1:08 pm > To: [email protected] (RBASE-L Mailing List) > > > Alex, > > Century is fine. You need to fix your THRESHOLD YEAR and your SEQUENCE. > > Change your THRESHOLD YEAR to 35 or so. That means for YY numbers above 35, > the "Century" will be 19. For numbers lower than 35, the Century will be 19 > + 1, or 20. > > You need to change the sequence to MMDDYY. With four Ys in sequence, you are > telling R:BASE that all dates being input already have all four digits of > the year. (Which they do not!) > > Bill > > On Fri, Mar 11, 2011 at 3:59 PM, Alex Sisk <[email protected]> wrote: > > > Hello, > > > > > > > > R:Base 5.5 user here. I'm guessing we're rare... > > > > > > > > I have a CSV file with a date column formatted MM/DD/YY. I am able to > > successfully load the file (as ASCII) into an R:Base 5.5 table with a > > matching structure. After importing the CSV file into the table, the date > > column contains MM/DD/00YY instead of MM/DD/20YY. Does anyone know why? > > Excel properly interprets the date when the file is opened. > > > > > > DATE format mm/dd/yyyy > > > > DATE sequence MMDDYYYY > > > > Century threshold YEAR is 0 > > > > Default CENTURY is 19 > > > > > > Not quite sure why our default century is 19....not sure what century > > threshold year is.... > > > > > > > > Thank you! > > > > > > > > Alex Sisk > > > > DiMark Inc > > > > (407) 786-4321 x108 > >
