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)