I am importing data from a CSV file that has a date column. When I import the data and use the str() command, I get the following:
$ date: chr "2020/8/14 12:09:00" "2020/8/14 12:10:00" "2020/8/14 12:11:00" "2020/8/14 12:12:00" ...
I want to convert the data to POSIXct instead of chr.
When I use the following command:
mdata$date <- as.POSIXct(farmdata$date, format = "%Y-%m-%d %H:%M:%S", tx = "GMT")
This is what I get
$ date: POSIXct, format: NA NA NA NA ..
Any idea why the dates are converted to NA?