topic Re: Can't Sort Table on "Date_Only" Field Type? in ArcGIS Pro Questions

Can't Sort Table on "Date_Only" Field Type?

VinceE — Thu, 21 Mar 2024 22:12:14 GMT

Anyone have any idea why you can sort a table based on a DATE field, but not a DATE ONLY field?

I have both field types in the example feature class below, but when it comes to the Sort tool, only the DATE field is an option. Simple oversight by Esri, or am I missing something?

Re: Can't Sort Table on "Date_Only" Field Type?

DanPatterson — Fri, 22 Mar 2024 00:29:02 GMT

In the table no problem

But with the Sort tool, it wouldn't even show the field name, so I entered it manually and got this error message

The operative word may be Date... and DateOnly isn't Date

Re: Can't Sort Table on "Date_Only" Field Type?

VinceE — Fri, 22 Mar 2024 00:30:07 GMT

Well at least the problem is repeatable. Thanks for testing.

Re: Can't Sort Table on "Date_Only" Field Type?

DrewFlater — Fri, 22 Mar 2024 16:27:51 GMT

Hi @VinceE , @DanPatterson

It's just a matter of prioritization. It will take many releases to update all tools that take an input field to support new field types and objects. This has not happened automatically for all geoprocessing tools in the first release of the new fields (3.2).

Can you please post an enhancement idea for Sort to support the new temporal field type(s) in the Pro Ideas page, so that we can gauge user demand and prioritize accordingly?

Thanks,
Drew

Re: Can't Sort Table on "Date_Only" Field Type?

VinceE — Fri, 22 Mar 2024 16:34:58 GMT

Appreciate the information Drew, thank you.

Re: Can't Sort Table on "Date_Only" Field Type?

VinceE — Fri, 29 Mar 2024 20:30:58 GMT

Hey @DrewFlater, a follow up to this. I just tried to use arcpy's AddField with a "BIGINTEGER" data type, and ran into a similar issue as above:

I'm not going to open a Pro Idea because... this issue of new data types clearly hasn't been addressed in a lot of places, so the "idea" would extremely general. I'll leave the prioritization decisions to you all. Thanks again for the initial reply.