Hi, Experts, please help. I have tried this for the whole day but could not figure it out. I have 'EventFromDate' and 'EventToDate' in my MS Acess. Now I would like to list events fall in between these dates using "today's" date as comparison.
Here is my query and please let me know where the problem is
<CFQUERY NAME="ListEvent" DATASOURCE="Eventdb" dbtype="ODBC">
SELECT * FROM Event
WHERE EventFromDate <= '#newdate#' AND EventToDate >= '#newdate#'
I keep getting
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
no matter how I do. Is there anything to do with my "Data Type" in Access?