Date Parameter in Excel Query

[Kumar]

I am using MS Query grabbing the info from an Oracle database an
placing it into Excel

I am querying on a date time field with e.g. 21/12/2003 07:00:00 an
just simply to use filter in the query on a specific date using a equal or greater operato
( keying 21/12/2003 in the filter prompt return
all items for that day and after that although the timestamps will be all different) This works perfectl

My problem is:
When I set a parameter for querying on a date time field, and input the date as 21/12/2003 on the prompt an error message appears, and no query results are displaye

Can anybody give suggestions to overcome this problem, will it a date format problem?
Any suggestions will be highly appreciated and will be useful for me.

 

[Beth Melton]

You'll need to declare a DateTime data type for the parameter under
View/Parameters. Otherwise your criteria is being treated as a text
string.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

I am using MS Query grabbing the info from an Oracle database and
placing it into Excel.

I am querying on a date time field with e.g. 21/12/2003 07:00:00 and
just simply to use filter in the query on a specific date using a equal or greater operator
( keying 21/12/2003 in the filter prompt returns
all items for that day and after that although the timestamps will

be all different) This works perfectly

My problem is:
When I set a parameter for querying on a date time field, and input

the date as 21/12/2003 on the prompt an error message appears, and no
query results are displayed

 

[Gordon]

Kumar cogitated deeply and scribbled thusly:

I am using MS Query grabbing the info from an Oracle database and
placing it into Excel.

I am querying on a date time field with e.g. 21/12/2003 07:00:00 and
just simply to use filter in the query on a specific date using a equal or greater operator
( keying 21/12/2003 in the filter prompt returns
all items for that day and after that although the timestamps will be all different) This works perfectly

My problem is:
When I set a parameter for querying on a date time field, and input the date as 21/12/2003 on the prompt an error message appears, and no query results are displayed

Can anybody give suggestions to overcome this problem, will it a date format problem?
Any suggestions will be highly appreciated and will be useful for me.

Try Microsoft.public.excel.misc - this group is for Windows XP, as in
the title, and as Excel is NOT part of windows XP..........And why on
EARTH are you posting this to a Word group?