Date Parameter in Excel Query

[Guest]

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?

 

[Guest]

But I cannot select the data type since that option is greyed out. When I go to the View/Parameter

----- Beth Melton wrote: ----

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

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

~~~~~~~~~~~~~~
Beth Melto
Microsoft Office MV

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

I am using MS Query grabbing the info from an Oracle database an
placing it into Excel
just simply to use filter in the query on a specific date using equal or greater operato
( keying 21/12/2003 in the filter prompt return
all items for that day and after that although the timestamps wil

be all different) This works perfectl

When I set a parameter for querying on a date time field, and inpu

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

 

[NobodyMan]

But I cannot select the data type since that option is greyed out. When I go to the View/Parameters

----- Beth Melton wrote: -----

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/



be all different) This works perfectly
the date as 21/12/2003 on the prompt an error message appears, and no
query results are displayed

Please take this question and responses to a more appropriate group.
This group is for the XP OS. Bye bye now!