In this query subdivide by date range adds columns for the earliest and latest year with records.
![](https://docs.bsbi.org/media/pages/ddb/searching/example-searches/species-earliest-most-recent-year/87e6019bc1-1700063518/screenshot-2023-10-09-at-14.12.29-600x.jpg)
This query uses the most recent year of any records with date range as the most recent year recorded. This may be incorrect. For the most recent year only, use 'subdivide by latest date' (see query below). This uses the start year of any date ranges as the most recent year, and is the more conservative measure.