As Brian indicated, you can certainly search by date. However, by
default, the appliance will use the date provided by the Last-Modified
HTTP response header. If that doesn't exist, then by default the
appliance will not associate any date with these documents. If these
articles are dynamically generated by something like
Java/.NET/PHP/ColdFusion, you should ensure that your program returns
the Last-Modified HTTP response header.
If you want to use something other than Last-Modified, you'll need to
configure the appliance to look for another value, such as a metadata
value, under Crawling ... Document Dates:
http://code.google.com/apis/searchappliance/documentation/64/admin_crawl/Introduction.html#docdatext
Now, if the value is really only available within the database, you'll
also need to build a metadata-and-URL feed to fetch the relevant
fields from the database and associate them with the document:
http://code.google.com/apis/searchappliance/documentation/64/feedsguide.html
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.