I would like to select a group of features that satisfy a date range. I have two layers, I want to use the Select by Attribute tool to select features in the first layer that are dated no more than 365 days prior to the date attached to a feature in the second layer. This brings up two problems. First, I don't know how to create the condition to query on date1date2-365 days - can someone help me with the proper syntax or point me to another question that I can use as a reference. The second issue is that I don't know how to tell the Query Builder in model builder what date2 is since I am looking for features in the first layer. Any help is appreciated.
أكثر...
أكثر...