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

Jeff Reichman reichmanj at sbcglobal.net
Mon Feb 13 01:23:10 CET 2017


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

 


	[[alternative HTML version deleted]]



More information about the R-help mailing list