BSBI Distribution Database > message board

Search for records for a specific day number

Any queries about using the BSBI database

Search for records for a specific day number

by AndyAmphlett » Thu Mar 28, 2019 10:19 am


I know that it is possible to group records by 'day number', but is there a way to search for records for a specific day number? The obvious example is where day number = 1, ie records made on 1st January (in any year)? There are quite a lot of records on the DDb that use 1st January as the date, but which obviously should have the date as the whole year (or even a date range). It would be useful to be able to search for such records.


Posts: 408
Joined: Fri Nov 23, 2012 9:32 am
name: Andy Amphlett

Re: Search for records for a specific day number

by admin » Thu Mar 28, 2019 10:27 am

Hi Andy,

Yes, the filter is 'more options' => 'attributes' => 'day or month'

If you find large sets where this is a problem then please let me know as it may be preferable for me to modify date-precision in the database rather than have a lot of records bulk-edited.

(a catch may be that the New Year Plant Hunt data will legitimately have 1st of Jan dates)
Tom Humphrey
Database Officer, Botanical Society of Britain and Ireland (BSBI)
c/o Centre for Ecology and Hydrology,Maclean Building, Crowmarsh Gifford, Wallingford, Oxon, OX10 8BB, UK.
User avatar
Posts: 438
Joined: Tue Nov 20, 2012 4:16 pm
name: Tom Humphrey

Return to Help and support