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.
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.
