nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

VinceE

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?

Find more posts tagged with

Geodatabase

Desktop

Accepted answers

DrewFlater

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

All comments

DanPatterson

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

VinceE

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

DrewFlater

Hi @VinceE , @DanPatterson

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

VinceE

Appreciate the information Drew, thank you.

VinceE

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:

ERROR 000800: The value is not a member of TEXT | FLOAT | DOUBLE | SHORT | LONG | DATE | BLOB | RASTER | GUID.
Failed to execute (AddField).

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.

KevinMacLeodEV

May 2026. Latest ArcGIS Pro just updated a few days ago. Looks like it's still not supported. Fyi to all.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.