While working on a perl script today, I came accross a strange error message from Win32::ODBC.

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

Now in the SQL statement, I was passing in the following VBA function:
    DateDiff( interval, date1, date2, [firstdayofweek], [firstweekofyear] )

When I passed in  DateDiff( "d", date1, date2), I received an error.  So I left off the double quotes and passed in DateDiff( d, date1, date2), which still failed.

Solution:  Pass it in with single quotes.

DateDiff( 'd', date1, date2)