1 Reply Latest reply on Jul 20, 2016 1:30 PM by Derrick Austin

    Date string m/d/yyyy being interpreted as d/m/yyyy

    Eduardo Rivera

      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.

      DateFormatIssue.png

       

      Here is the source data, the column is a string type containing a date time value in m/d/yyyy h:mm:ss format

       

      DateFormatIssueSource.png