Skip to content
Prev 367109 / 398506 Next

Converting Excel Date format into R-Date formats

Jeff Reichman 
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.Date, "%d-%b-%y")

 

as it return "NA"

 

Jeff

Thread (2 messages)

Jeff Reichman Converting Excel Date format into R-Date formats Feb 12 Jim Lemon Converting Excel Date format into R-Date formats Feb 12