I've been using ODBC and Perl ODBC.pm to access an MS Access database.  I
can easily store info in a date field (ie. "insert into table (date) values
('1997-08-25')".

However, I can't figure out how to do an SQL query using a date field.
I've tried everything I can think of (ie. "select * from table where
date='1997-05-31'") with no success.

Thanks in advance!

Try:
"select * from table where date={d '1997-05-31'}"
This is the ODBC specific date format. Since different DBM's implement date
stamps in different ways, the ODBC Driver will convert the ODBC specific
format to it's own format. Hence this format will work for any ODBC Driver.
dave