You have a syntax error. The syntax logic tries to figure out as best as it can, what you did wrong but sometimes it does not do a good job. Assuming your post did not loose anything in the process, here are some issues:
The syntax of BETWEEN is:
You don’t have a AND in you expression so it does not know “between” what and what it is supposed to find. It looks like you are working with dates.
Your parentheses are not balanced count them there is one missing. I don’t know your intent so you need to figure out where it is supposed to go.