Hi Rohit,
Thanks for your answer. Unfortunately, I can't get it to work, and I am obviously doing something dumb. Just to be clear, I am importing a csv log file that contains dates in the format 06/11/2019 10:55:44 AM. I want to convert them to DateObjects. The conversion does work, but it complains that it is ambiguous. Adding the format list, as you suggested, produces a "cannot be interpreted as a date." message
Here is the code snippet - can you see what I am doing wrong?
ecicc = Import["/Users/andy/Downloads/participants_497478659.csv"];
In[65]:= ecicc[[2, 3]]
Out[65]= "06/11/2019 10:55:44 AM"
ecicc[[2 ;; All, 3]] = DateObject[{#, {"Month", "/", "Day", "/", "Year", "hour", ":",
"Minute", ":", "Seconds"}}] & /@ ecicc[[2 ;; All, 3]];
ecicc[[2 ;; All, 4]] = DateObject[{#, {"Month", "/", "Day", "/", "Year", "hour", ":",
"Minute", ":", "Seconds"}}] & /@ ecicc[[2 ;; All, 4]];
DateObject::str: String 06/11/2019 10:58:51 AM cannot be interpreted as a date.
General::stop: Further output of DateObject::str will be suppressed during this calculation.
DateObject::str: String 06/11/2019 12:54:08 PM cannot be interpreted as a date.
General::stop: Further output of DateObject::str will be suppressed during this calculation.
