Topic: Report constraint end date/start date?
We have very recently added a large (420,000) flora atlas dataset to Recorder 6 where every record is a tetrad with a date range of 1974-1997. We'd really like rare and protected species records from this survey to be returned in our standard consultant data requests in future, because often this is the best information available for flora species in most parts of the county.
We use the report wizard for our standard data requests and a constraint of the event date being post 31/12/1979 to remove historical data, of which we have quite a lot, being a museum based records centre.
On testing, this doesn't pick up any of these flora records, so it must work on the start date rather than the end date of a date range. Does anyone have any suggestions for a work around? So far my colleagues and I have thought of:
- Changing the date range on all the records - this would be bad data management so I am reluctant to do this
- adding duplicates of the rare and protected species records only in a separate survey for data requests and changing the date on those (still bad data management)
- no longer using the date constraint in Recorder and adding an extra step to our excel macros to delete historical records (guess this would work ok, but we prefer doing as much in Recorder as we can before exporting results)
- no longer using a date cut-off, or changing it to 1969 (whereas really we were thinking it was time to increase the cut-off, perhaps to 1989)
Does anyone have any other suggestions or work arounds?
Teresa Frost | Wetland Bird Survey National Organiser | BTO
Other hat | National Forum for Biological Recording Council
(Old hats | NBN Board, ALERC Board, CBDC, KMBRC)