Syntax error with ODBC drivers and DATEADD

Question

I am using ODBC drivers and DATEADD I just cant get the syntax right

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
SELECT DATEADD (month, -2, #2020-10-10 00:00:00#) FROM TblCalibItems;

Answer 1

Hi，@JXWD

Welcome to Microsoft T-SQL Q&A Forum!

First of all, confirm again whether you are a SQL Server database, because according to your description, the odbc connection function of the access database you use.
in Tsql, the following from table is not needed, because you are just printing the first two months date,, and did not get any information from the table, I guess your table stores data in a date format, you can use parameter to store date data.

 SELECT DATEADD (month, -2, parameter) FROM TblCalibItems  

Let's look at how to use the DateAdd function in MS Access:


Best regards,
Bert Zhou

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

SELECT DATEADD ("m", -2, #2020-10-10 00:00:00#)

Answer 3

You missed the (single) quotes around the first parameter (month), and also that "month" is not a valid parameter for the ODBC version of the method, you have to use "m" instead so it should be:

SELECT DATEADD ('m', -2, #2020-10-10 00:00:00#) FROM TblCalibItems;