ODBC Date/time query (1 Viewer)

vicsalt

Registered User.
Local time
Today, 15:42
Joined
Aug 22, 2008
Messages
48
I am connecting to a ODBC databaste table containing a date and time field, I want to strip out the date only. I created a query and used the DateValue function, run query, great i get a list of data with dates only, Great.

However when i then put a specific date in the criteria say 10/3/18, knowing there is data for this date, my query returns no results ?

Help would be greatly appreciated.
 

Users who are viewing this thread

Top Bottom