Some dates appearing in different format in ArcGIS pro

[Ashok_kumarSankaranarayanan]

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.

[DanPatterson]

Date fields—ArcGIS Pro | Documentation

Work with Microsoft Excel files in ArcGIS Pro—ArcGIS Pro | Documentation

In excel, you need to make sure that your date fields are explicitly formatted as dates otherwise they are converted to text. 

A missing date might be enough to trigger such a conversion.

Check your windows settings too.

Finally the international date format (YYYY-MM-DD) has distinct advantages over other methods since it is hard to foul up the order.

[Ashok_kumarSankaranarayanan]

I exported the excel and selected the dates,right clicked and formatted into mm/dd/yyyy format , got back in ArcGIS pro as excel to table, checked again some dates are changing into dd/mm/yyyy format,what do you mean by explicitly formatted,Thank you for your suggestion

[DanPatterson]

And what are your computer date settings?  

Do you mean "some" within a date field? or in some tables? there is a difference.

Did you rule out missing dates as I suggested?

Barring that, screen grabs may help narrow down the issue

[Ashok_kumarSankaranarayanan]

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 datearcgis pro dateall dates till 13th and after mm/dd/yyyy ,i have attached the screen grabs

[JoeBorgione]

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

[Ashok_kumarSankaranarayanan]

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