Re: [R] Converting Excel Date format into R-Date formats

Hi Jeff, Most likely the "Event Date" field is a factor. Try this: df$Event.Date <- as.Date(as.character(df$Event.Date), "%d-%b-%y") Also beware of Excel's habit of silently converting mixed date formats (i.e. dd/mm/ and mm/dd/) to one or the other format. The only way I know to prevent

[R] Converting Excel Date format into R-Date formats

R-Help Group What is the proper way to convert excel date formats to R-Date format. Event ID Event Date Event Type 250013 1-Jan-09 NSAG Attack 250015 1-Jan-09 NSAG Attack 250016 1-Jan-09 NSAG Attack Obviously this is wrong df$Event.Date <- as.Date(df$Event.Da