Extract day of the week from a date field in ArcGIS

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: