Hey Guys and Gals,
I am having an issue with an SQL string. I am trying to pull some results from my MySQL database that will be between a set of dates given by the user.
I have attached my SQL string...
Also, the date field in my MySQL DB is a DATE field, not a DATETIME.
Any help would be appreciated!
"SELECT cancelStatus, orderDate, delTelephone, invTelephone, orderDate, invName, emailaddress, ordertotal, ocCusEmail FROM malsinfo WHERE ocCusEmail = '" & sessionName & "' AND orderDate BETWEEN = " & startDate & " AND " & endDate & ""