Sql statement with datediff (1 Viewer)

[Joy83]

I have sql query
Datediff(“m”,date1,date2)
How to replace the “”
Access is expecting the end of statement with this syntax

 

[GinaWhipp]

Try using single quotes.

 

[onur_can]

Hello
link here may help
https://accessapplication.blogspot.com/2019/03/sql-datediffparametreler-iki-tarih.html

 

[Gasman]

Show the sql code? (within code tags)

 

[Joy83]

Thanks it worked with single quote

 

[GinaWhipp]

Thanks it worked with single quote

You're welcome.

As a side note, whenever you get that message that is the reason. With the Statement you need to change the double quotes to single quotes and only have the double quotes for line continuation. It was thinking your double quotes were at the end of the line and\or Statement and obviously it was not.