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
Leave a Reply