Using ArcGIS Desktop 10.6.1. I have a large dataset that I need to view sequentially by month AND year. Instead of using Select by Attribute for each month/year combo (i.e. February 2017-May 2019 for 28 total feature classes).

Can this be done in ModelBuilder?

Data is currently in a file geodatabase and I'm looking to export each date/month as a feature class.


If the field holding your dates are of date data type, then:

(If the field is already text and year-month then all you need is Split By Attributes)

With Split By Attributes you probably dont need to use ModelBuilder and Iterators.

  • Excellent! I actually don't need to extract a date. They are two standalone columns - one as Month and one as Year. Would you suggest I concatenate the two into one new column and then use Split by Attributes? – Susan Jun 12 at 18:04
  • Nice! No you can pass both fields to Split By Attributes – BERA Jun 12 at 18:05
  • 1
    Yeah, I tried selecting both fields in Split By Attributes and nothing happened. I just concatenated both fields into one new column and ran it again. It worked! Thanks so much for the help! – Susan Jun 12 at 18:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.