AI Center Behavior of date format when set to Auto in AI Center

AI Center is identifying the dates as (yyyy-MM-dd) which is okay. But sometimes it is identifying the dates as (yyyy-dd-MM) for less than 12 scenario and as (yyyy-MM-dd) for greater than 12 scenario. Hence discrepancy in the date format happens. Please look into the attachment. That document contains list of dates with both less than and greater than 12 scenarios and the system identification went wrong.

  1. If a document contains list of dates with both month and date values less than 12 – It gets identified as YYYY-DD-MM
  2. If a document contains list of dates with date value greater than 12 – It gets identified as YYYY-MM-DD
  3. If a document contains list of dates with a mixture of 1st and 2nd scenario – It gets identified as YYYY-MM-DD .