Attached is a script to add a function called value_on_date, which finds the value of a specific field on a specific date. It was developed in the Florida Natural Areas Inventory by former data manager Glenn Woodsum. The script contains documentation on how to use the function.


To add it to Biotics, your program's administrative user must log into your database as biotics_dlink and paste in the script. Execute the script and  the message "Function created." will be displayed.


In Biotics, select Grant/Refresh Database Privileges under the Configuration menu. This will make the function usable in Query Builder as well as Toad, SQL Developer, etc.