MySQL date between 2 dates but error msg 2011
Posted on 2011-09-12
Here is the code that will Not run on MySQL on a Windows server:
SELECT CustomerYN, ActiveYN, FirstName, MidName, LastName, EmailMain, CoProfile, GoalUrgent, Mx1, Title, CoName, OrigContactDate
WHERE (OrigContactDate BETWEEN '2011-03-12' AND '2011-08-31')
ORDER BY OrigContactDate, LastName
There seems to be a problem with the dates and the BETWEEN. I find lots of examples but none that fixes this problem.