Sign In
Create Account
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.
arcgis selection issue
Started by
lc500
, May 14 2012 04:00 PM
2 replies to this topic
#1
Posted 14 May 2012 - 04:00 PM
lc500
-
- Validated Member
-
- 11 posts
Contributor
-
No Country Selected
-
Back to top
#2
Posted 15 May 2012 - 03:52 AM
frax
-
- Associate Admin
-
- 2,246 posts
Hall of Fame
- Gender:Male
- Location:Stockholm, Sweden
- Interests:music, hiking, friends, nature, photography, traveling. and maps!
-
Sweden
-
date format "6:00:00 AM"
Is this a string column? Can you try parsing the strings and convert them to proper date/time values? (using python, for instance)
#3
Posted 15 May 2012 - 11:06 AM
Craig Jr
-
- Validated Member
-
- 14 posts
Contributor
- Gender:Male
- Location:Cold Spring, NY
-
United States
-
You can try querying from the attribute table with # instead of " as you would with a string field. Example: #05/15/2012#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"
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
