SQL syntax

Hi

This means that there is a problem with the way that the date is being used in the SQL statement.

To fix this error, you need to check the SQL statement and make sure that the date is being used correctly. The date should be enclosed in single quotes (')

Like

SELECT * FROM table WHERE date = ‘2023-09-12’

Refer this thread for some insights if u r using variable

Cheers @omar_ismail