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 >
