BETWEEN two dates in an Access database using SQL

Question

Me again, sorry.

Trying to get all the data between two dates in my Access Database. The data type for the column is "Date/Time" which I believe is correct.

SELECT *
FROM SaleProperty
WHERE MarketDate BETWEEN '01/05/2013' AND '30/06/2013';

When I use this, I am told that there is a data mismatch and the query does not work. Sorry again for what is probably a very basic question but I have no idea what I am doing wrong.

Cheers again!

squillman · Accepted Answer · 2014-02-19 19:46:08Z

1

Access (Jet) uses # to identify a date literal. Try this:

SELECT *
FROM SaleProperty
WHERE MarketDate BETWEEN #01/05/2013# AND #30/06/2013#;

answered Feb 19, 2014 at 19:46

squillman

13.7k3 gold badges45 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Michael Delahorne Over a year ago

Ah, I didn't think of looking for things which only Access does when it comes to dates. Thank you!

Collectives™ on Stack Overflow

BETWEEN two dates in an Access database using SQL

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related