I'm using ArcMap 10.3. When I use the Identify tool, I often have many results and would like to sort those results in the Identify window. If I right-click on the layer name or features in Identify results, I can "Sort Ascending." This would accomplish the goal in most cases...but I have set the display field for this layer to use a date field, and I would like to sort the results by date values chronologically. When I sort ascending, it sorts the date values by month, like so:

  • 1/1/2019
  • 2/1/2014
  • 3/1/2016
  • etc.

But this is not actually chronological.

Any ideas?

The data I'm using is a very large feature class stored on my organization's network, which I am not able to edit.

  • 4
    Issues such as this are why ISO standards are born. I can't help with your direct problem however if the ISO date format is used then the sorting is automatically chronological: YYYY-MM-DD – JimT Jul 12 at 22:02
  • 2
    What type of geodatabase is this stored in? What data type is being used to store what look like dates (but could be strings)? – PolyGeo Jul 12 at 22:30
  • I've been able to replicate the issue, looks like the sort function ignores the fact it is date field and treats is as text field so you get a non-chronological order. I suspect there is no solution to this? – Hornbydd Jul 13 at 12:12
  • 1
    can you add a field and then format date w field calculator to ISO standard, then sort, then remove field if needed? – Gary Lester Jul 13 at 13:45
  • 1
    @MattLeonard would the db manager create a table view for you and recast the date as something that can be sorted? I think this can be done in the select statement. – Gary Lester Jul 16 at 21:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.