To create this query, enter the hectad into the grid reference field, add a group by in more options > grouping and choose taxon > taxon name. Then add the latest date option available as a subdivide clause, found by clicking on more options > grouping.
Hectad SW84 in Cornwall has a huge number of records on the DDb. This query returns latest year for 1602 taxa.

Changing ‘latest date’ to ‘date range (min/max date)’ shows the earliest and most recent dates.

In some cases, the records have vague date ranges, eg. ‘before 1987’, which has an end year but not a start (minimum) year - so the earliest date shows as a blank. You can see this is you click on the earliest date column header to sort the records by that field.