Appreciate any help on this. I have a column of dates formatted as %m/%d/%y %H:%M. The column datatype is col_datetime. When I view the dataset, the datatype is correct however the date values are all NA. I’ve checked the format of the date versus the format I specified many times and it looks fine. [Correct datatype, but no data. image
Code in question: started_at = col_datetime(format = “%m/%d/%y %H:%M”)
Input: 6/3/20 11:20 as a string
Output: “NA” date value, column datatype set correctly. See image
Verified the argument of col_datetime precisely matches that of the data.
Tried using as.POSIXct instead of col_date_time.
Tried using Date.
Validated source data could be formatted as desired. To verify no hidden characters came with the data.
Daniel Boggs is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.