CODEWITHSUNDEEP
sqldatabasems-access
BlackCat
BlackCat

Reputation: 2044

Why Date/Time statement in access returning no values?

Table has an End_Date column (Datatype: Date/time) with last date of every month

When I run the query I expect all records with End Date less than for example 31-Dec-2019

Select * from Table where End_Date < 31/12/2019

But it returns no result

Upvotes: 0

Views: 29

Answers (1)

Applecore
Applecore

Reputation: 4099

When dealing with dates in Access, you need to ensure that they are wrapped in octothorpes ("#"):

SELECT * FROM Table WHERE End_Date<#31/12/2019#

Regards,

Upvotes: 4

Related Questions