Filtering a date & time field

  • Thread starter Thread starter Graham Colling
  • Start date Start date
G

Graham Colling

I am developing Access2000 queries from ODBC linked
tables in an Oracle Database. One of the fields has a
date and time field with the following syntax 'dd/mm/yyyy
hh:mm:ss'. I need to filter by date (but not time),
either selecting a single day or range of days, allowing
the user to stipulate the dates.

My efforts to date have failed, can anyone suggest the
criteria syntax I need to use to achieve my aim?

Thanks in advance for any assistance.
 
Is the field that has the date / time value in Oracle DB actually a text
string? Or is it a date/time formatted field?

If it's a text string, you could use some nested functions to extract a date
value from it:

DateValue(Mid([OracleField], 4, 3) & Left([OracleField], 3) &
Mid([OracleField], 7, 4))

If it's a date/time field simliar to what ACCESS uses for storing dates and
times (decimal number), then you could just use the DateValue function by
itself:

DateValue([OracleField])
 
Back
Top