MySQL to Access Question

[DaNuGai]

I have the following Select Statement that works in MySQL

SELECT EventID, Date_Format(DateFrom, '%b %e'), Date_Format(DateTo, '%b %e'), EventTitle, Event FROM events WHERE DateTo BETWEEN date_format(curdate(), '%Y-%m-1') AND date_sub( date_format( date_add( curdate(), interval 3 month), '%Y-%m-1'), interval 1 day)ORDER BY DateFrom ASC

However, in the Access Database, I am getting the following error:

Syntax error (missing operator) in query expression 'DateTo BETWEEN date_form...

Any help will be greatly appreciated. Thanks in advance.

[eight968]

It may be having trouble with intervals. You could try to use DateAdd("d", -1, DateAdd("m", 3" DateTo))