Is there a way to determine the format of a date-time column in an excel file, and then read it correctly? read_excel() reads it as character by default. Challenge is that there are multiple files and I don't know the date-time formats in each without opening the files #RStats
4
1
Sounds like a job for the anytime package -- it will happily convert from any reasonable format to Datetime (ie POSIXct) or Date -- without the need to supply a format string.
cran.r-project.org/package=a…
Jun 25, 2022 · 7:50 PM UTC
1
9

