Why my code in R do not compile with Date() function?

Question

MYCODE

setwd("~/R/Scripts - todos/Dolar")
dolardia <- read.xlsx ("com3500.xlsx", sheet = "Hoja1")
view(dolardia$FECHA)
str(dolardia$FECHA)

col1 <- as.Date(dolardia$FECHA, format= "%d/%m/%y")

THE PROBLEM

col1 <- as.Date(dolardia$FECHA, format= "%d/%m/%y")

Error in as.Date.numeric(dolardia$FECHA, format = "%d/%m/%y"):
'origin' must be supplied

it´s don´t have an error, but the information is not correct. because when i try to see it with a view(col1), show me NA for all obs — Dieguexs, Jan 29 '21 at 18:57
Hola Dieguexz. Could you please paste the output that the following code will generate? dput(head(dolardia)) — Nicolás Velásquez, Jan 29 '21 at 19:55
It would be very useful to put an example of the dates that you're trying to parse. There have been several answers and you haven't put a MWE yet. — StrayChild01, Jan 30 '21 at 04:22

score 0 · Answer 1 · answered Jan 29 '21 at 20:00

0

If the date is recent (i.e. after Unix epoch - January 1st, 1970), you could try

col1 <- as.Date(dolardia$FECHA, format= "%d/%m/%y", origin = "1970-01-01")

answered Jan 29 '21 at 20:00

Nicolás Velásquez

4,818
9
21

Why my code in R do not compile with Date() function?

MYCODE

THE PROBLEM

1 Answers1