How convert numeric value to date in R (same as Short date in excel)?

Question

I want to convert numeric date format to date. I.E. I have value 44109, but want to convert it to 2020-10-06. How is it possible?

See `help("as.Date")`, in particular the *Examples* there. – Roland Oct 07 '20 at 08:41 — Roland, Oct 07 '20 at 08:41

score 0 · Answer 1 · answered Oct 07 '20 at 08:42

0

Try something like below

> as.Date(44109,origin = "1900-01-01")
[1] "2020-10-07"

answered Oct 07 '20 at 08:42

ThomasIsCoding

score 0 · Answer 2 · answered Oct 07 '20 at 08:43

0

this works as well

x <-  as.POSIXct(44109 * (60*60*24), origin="1899-12-30", tz="GMT")

"2020-10-05 GMT"

answered Oct 07 '20 at 08:43

D.J

2 Answers2