If the table is in a SQL database, best would be to use some DBI module to access the database and get the date with a SELECT statement like

SELECT FROM table WHERE partnbr=? AND date<? ORDER BY DATE DESCENDING LIMIT 1

I'm no SQL expert, but maybe this will set you on the right track.