Date format issue.

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20110628/affaa4d7/attachment.pl>
You get the NA since it is indeterminate as to the date; paste on a 1
for the day"
v<-c("Mar-80")
as.Date(paste(v, '1'),format="%b-%y %d")
[1] "1980-03-01"
Dear R helpers,

I have 2 questions : -

1. My excel sheet has a column with dates like 01/03/1980 which is formatted
as 03/80 when I read this into R it reads as Mar-80. How can I read it in
the source format ?

2.

v<-c("Mar-80")
as.Date(v,format="%b-%y")
[1] NA

Could someone please tell me where I am wrong in this date format conversion
?

Thank you all very much.

? ? ? ?[[alternative HTML version deleted]]

______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Jim Holtman
Data Munger Guru

What is the problem that you are trying to solve?
An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20110628/781b5c85/attachment.pl>

Dear R helpers,

I have 2 questions : -

1. My excel sheet has a column with dates like 01/03/1980 which is  
formatted
as 03/80 when I read this into R it reads as Mar-80.
You should be able to change that from the format menu in Excel. If  
you use a "custom" format of yyyy-mm-dd and then save as csv you get  
dates in "%Y-%m-%d" acceptable format for importing, namely your date  
which on the data entry line appears as 3/1/80 appears in the cell as  
1980-03-01, and likewise in the text output the same way, and could be  
input using a colClasses argument of "Date".
How can I read it in
the source format ?

2.

v<-c("Mar-80")
as.Date(v,format="%b-%y")
[1] NA

Could someone please tell me where I am wrong in this date format  
conversion
?

David Winsemius, MD
West Hartford, CT