Z
Zachry1
I have linked through odbc to Oracle tables. The table has a date field that
I want to use to limit the results of the query.
When I place the exact date criteria through the query, such as >=#17/2005
10:35:40 AM# I get valid results.
When I use >=#17/2005# I get zero records.
When I embed the time, such as >=#17/2005 0:0:01AM# again I get zero records.
I would like to have the query limit the records to the valid date ranges I
requested. Has anyone been able to do this?
I want to use to limit the results of the query.
When I place the exact date criteria through the query, such as >=#17/2005
10:35:40 AM# I get valid results.
When I use >=#17/2005# I get zero records.
When I embed the time, such as >=#17/2005 0:0:01AM# again I get zero records.
I would like to have the query limit the records to the valid date ranges I
requested. Has anyone been able to do this?