SubscriptionMS Access: Search between Date/Time
If you have tried to search your records between two specific dates by running the SQL query expression as follows:
SELECT * FROM tbl_records WHERE createDate BETWEEN ‘01/01/2008 00:00:00 PM’ AND ‘31/12/2008 00:00:00 PM’
,I am sure that you will get the error message something like this: “Data type mismatch in criteria expression.”
Well, this is because [...]
