I have a data source from access and in this a table that has a column with the date & time of an event and is in m/d/yyyy h:mm:ss AM/PM format, the workbook was working fine it recognized this date in the correct format but since the last refresh of the extract it has been taking the date as d/m/yyyy h:mm:ss AM/PM for example the value 2/11/2015 4:52:29 PM is being interpreted as November, 2 2015 but it should be February, 11 2015.
I already check the locale and its set to United States (Prior to that it was Automatic), any ideas?
In the image we data for all the remaining months of 2016, but the last month in the data source is July 2016.
Here is the source data, the column is a string type containing a date time value in m/d/yyyy h:mm:ss format
Worst case, you should be able to pull this in as a string and use DATEPARSE to parse it correctly.