| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MS Query DateTime String
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AHHH! Again | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| Querying 2 databases with one query string | Excel Discussion (Misc queries) | |||
| Excel Database Query String Too Long | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
