CODEWITHSUNDEEP
c#sqldatabasems-access
lulitha
lulitha

Reputation: 103

how do i Filter Only from date [without time] in MS Access Query

How doi find something only date, the query need time too

 (((TABLE.[UpdatedDate])=#31/07/2018#))

== No result

  (((TABLE.[UpdatedDate])=#31/07/2018 13:20:43#))

== Then result done.

i need to search from date only.

Upvotes: 3

Views: 2639

Answers (2)

Serkan Arslan
Serkan Arslan

Reputation: 13393

You can try this

((( CDate(Format(TABLE.[UpdatedDate], "yyyy-mm-dd")) )=#31/07/2018#))

Upvotes: 2

Jas
Jas

Reputation: 17

You'll need to format the first DateTime variable to just date only. Something like Birthday.ToString("yyyy-MM-dd") for the first check. Perhaps store it in another variable and use that for the first check.

Than use the DateTime data you have to do the second check.

Upvotes: 0

Related Questions