SQL Query to get records between two dates in MS Access database

on Jun 23, 2015 03:42 AM

i have following query executed but no records fetched inspite of that in database there were record which full fill mention date criteria:

select * from vw_opdslip where opdate between 14/06/2015 and 16/06/2015

In my database there opdate field has datatype datetime and its format is set to shortdate.

Now how can i achieve this records using above query what modification will require there??

Download FREE API for Word, Excel and PDF in ASP.Net: Download
on Jun 24, 2015 12:23 PM

by putting # before and after date value we can achieve this problem's solution.

select * from vw_opdslip where opdate 
between #14/06/2015# and #16/06/2015#