Gianluca Suzzi Gianluca Suzzi - 3 months ago 9
C# Question

ACCESS fails with DATETIME query

I've a simple query which extract some records according to a DateTime field.
I can't explain why but with some dates it doesn't work (null result).
It seems that it doesn't work with first days of month while it works with last days (10th and above).

Access Table and SQL Query

In the example above it doesn't work with #04/09/2016# while it works with #09/09/2016#!

Could it depend on Date Format?

Answer

In SQL view the date is always written #mm/dd/yyyy#, even if in the design view it is #dd/mm/yyyy#. So your SQL is requesting April 9. Is that your intent ?