Topic: NBN uploads: return date_type function


Does anybody have the algorithm to generate NBN upload date_types? I imagine the Recorder6 database uses a function and takes the start date and end date as parameters to return D, DD, O, OO etc.

I want to embed it into a spreadsheet as a function in order to upload a large batch of records to the NBN. Ideally I don't want to have to import this data into our copy of Recorder6 just to obtain a date_type.

All of the other fields I can easily lookup i.e. NBN_taxon_key.