MS Query DateTime String

[Guest]

I have an ODBC connection to and Oracle db through MS Query. One of the
fields I'm trying to work on is a DateTime field and I'm having problems
selecting a particular date out of the field.
How can I look for "31/01/2006" when the info in the table is "2006-01-31
06:00:00".
Note different slashes and different format as well as having the time.

Thanks in advance
Dean

 

[Guest]

Ok,
Now I have...
(to_char(VP_SCHEDULE.SHIFTSTARTDATE,'yyyy-mm-dd')='2006-01-31') and it
selects the correct data from the database but I want to be able to have the
user enter the date into a cell on the spreadsheet, usually i'd change the
date into [?] and then when run the query would ask for a parimeter. Here it
gives me an error saying that the "Literal does not match format string" even
when I enter it exactly.

Any one got any ideas how I can round this?

Dean