Some dates appearing in different format in ArcGIS pro

Question

Hi all, data initially in excel showing mm/dd/yyyy format as needed, but when i convert excel to table in ArcGIS pro, some dates especially first 10 days of month is showing in dd/mm/yyyy, i need help in converting the dates back to mm//dd/yyyy in ArcGIS pro,Thank you all for great contributions.

Ashok_kumarSankaranarayanan · Answer

Yes it was really tricky , as the date was not continuous,same dates appears frequently , i exported as excel file and grouped the similar dates and change it manually and got back to ArcGIS pro,now it is clean,thank you

Ashok_kumarSankaranarayanan · Answer

Basically i am doing hotspot analysis, I am an emergency physician,new to arcgis pro,learning from you people,And my date may not be continuous,and it is some within date field,all are first 12 days of month,i tried changing date format in excel by exporting again,but the specific dates are not changing in excel also.
date format computerarcgis pro date
arcgis pro dateall dates till 13th and after mm/dd/yyyy
 ,i have attached the screen grabs

JoeBorgione · Answer

Date fields in Excel can be tricky sometimes and as @DanPatterson mentions if there are blank or null values in your spreadsheet things get even worse.  See this post of mine from last year:

https://community.esri.com/t5/arcgis-pro-questions/date-field-in-excel-to-table-tool/td-p/21251