vb.net - Date Filtering in Ms Access Query (Interesting)

Question

Its look like the sample but I can't find what this is?

Here are what i want final result =>

Here is my query=>

 Select 
a.staffname,
a.staffno,
a.cntname 
From [Clisys] a 
where 
CDate([a.acdate]) <= #02/08/2018# and  
CntNo='H0128C' and 
[a.JobCode] like '1**/2018' and 
[a.acdate] is Not Null

But problem is when i select like that, I get nothing. But when i change where cause like that=>

 where 
    CDate([a.acdate]) <= #02/08/2019# and  
    CntNo='H0128C' and 
    [a.JobCode] like '1**/2018' and 
    [a.acdate] is Not Null

I get what i want.But why if i select with 2018 is not working?

Answer 1

Always handle dates as dates, not strings, not numbers, no exceptions.

And when you write SQL, use the correct syntax. The text expression for a date value must be like mm/dd/yyyy or yyyy/mm/dd.

You did use dd/mm/yyyy, thus your date was read as 2018-02-08. So use:

CDate([a.acdate]) <= #2018/08/02#

and your query will run as expected.