So your are ArcGIS 10 (ArcView licence only) and have a large dataset with a Date field. You want to select all those dates that fall on a specific day or days of the week. How would use do this only using the tools in ArcGIS? Try this:

1. Add an integer field to the table

2. Use the field calculator and vbscript syntax YourDOWField = DatePart (“w”, [YourDateField]).

3. The field will then contain values 1-7 which translates to Sunday – Saturday. You can then select on this.

Tripp Corbin, CFM, GISP
Vice President, GIS/IT
Esri Authorized Instructor
Esri Certified ArcGIS Desktop 10 Associate
Keck & Wood, Inc.
www.keckwood.com
Advertisements