topic Re: Some dates appearing in different format in ArcGIS pro in ArcGIS Pro Questions

Some dates appearing in different format in ArcGIS pro

Ashok_kumarSankaranarayanan — Mon, 14 Dec 2020 09:07:36 GMT

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.

Re: Some dates appearing in different format in ArcGIS pro

DanPatterson — Mon, 14 Dec 2020 11:32:47 GMT

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.

Re: Some dates appearing in different format in ArcGIS pro

Ashok_kumarSankaranarayanan — Mon, 14 Dec 2020 15:00:17 GMT

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

Re: Some dates appearing in different format in ArcGIS pro

DanPatterson — Mon, 14 Dec 2020 15:14:17 GMT

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

Re: Some dates appearing in different format in ArcGIS pro

JoeBorgione — Mon, 14 Dec 2020 16:01:16 GMT

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

Re: Some dates appearing in different format in ArcGIS pro

Ashok_kumarSankaranarayanan — Mon, 14 Dec 2020 17:13:29 GMT

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

Re: Some dates appearing in different format in ArcGIS pro

Ashok_kumarSankaranarayanan — Thu, 17 Dec 2020 09:45:42 GMT

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