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

Last Reply on Jun 24, 2015 12:23 PM By Prasunjeet

Posted 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??

Posted 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#

 

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html