do not know how to convert 'outcome[, col]' to class “Date”

Asked Jun 22 '17 at 18:38

Active Jun 22 '17 at 18:38

Viewed 218 times

I wrote the following script in R software in order to converting date format in a prospective cohort data. But, I get an odd error. Could everyone help me? Any idea?

Code:

for(col in colnames(outcome)){
  if(startsWith(col, "eventdate_")){
    outcome[, col] <- as.Date(outcome[, col],"%Y-%m-%d")
  }
}

Error: Error in as.Date.default(outcome[, col], format = "%Y-%m-%d") : do not know how to convert 'outcome[, col]' to class “Date”

asked Jun 22 '17 at 18:38

Milad Nazarzadeh

why are you going about it in a `for` loop? – akash87 Jun 22 '17 at 18:38
For applying on all time variables. Do you have any suggestion? TNX – Milad Nazarzadeh Jun 22 '17 at 18:40
is it in character format? if so, you can `gsub` `eventdate_` with `""` so that you only have the dates. then you can use the `as.Date` function on the character date – sweetmusicality Jun 22 '17 at 18:41
what is `class(outcome)` and what is the format of the `col`s you are trying to convert to date? Also see [how to make a great R reproducible example](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example) – Adam Spannbauer Jun 22 '17 at 18:45
@ Adam Spannbauer outcome is a csv file name contain date variables. col is date as yyyy-mm-ddformat – Milad Nazarzadeh Jun 22 '17 at 18:50
lubridate is a pretty standard package that converts the date into any format requested (ymd, dmy, etc.). – Raj Padmanabhan Jun 22 '17 at 20:48

do not know how to convert 'outcome[, col]' to class “Date”

0 Answers0