Select date attributes within 'days from today' in ArcGIS Pro using Select by attributes with SQL

Summary

The steps provided describe how to select date attributes within a certain number of days from the present in ArcGIS Pro using Select by Attributes with an SQL expression.

Procedure

For example, to select records within 90 days from today:

1. In ArcGIS Pro, go to the attribute table containing the records to filter, and click Select by Attributes.
2. Toggle the SQL button on, as shown in the next image.

3. In the SQL expression box, type the following expression:
   • Where date is the date field name, and 90 is the number of the days of the period in question.

date >= CURRENT_DATE()
AND
date - 90 <= CURRENT_DATE()

4. Run the tool.