arcgis selection issue

lc500

Posted 14 May 2012 - 04:00 PM

lc500

Contributor

Validated Member

11 posts

No Country Selected

I want to select a number of rows from an attribute table with the selection tool. The problem is that the information is in date format "6:00:00 AM" and it is not reading the information. Therefore I have to do it manually, and I have like 50,000 rows in the table which is impossible.

How can I get around this? I've tried just sorting by time in ascending order, which works, but it takes a million years. I've also tried using the selection by attributes, this doesnt work.