I have downloaded data set from an agency website and the datetime column (labelled ‘date’ in the df) for two of the files is not converting from chr to datetime.
For the other files the date time is in numeric format (example “01/09/2023 00:01:00”) and not ’01-oct-2023 00:01:00′ and they convert using dmy_hm. It may be an issue with the month abbreviation as oct instead of Oct but I’m really not sure. I’ve tried various methods but none are working for me and I’d be grateful for any help.