LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Parameter query conversion error on date

I have a pivot table that uses a MS Query to retrieve data. I have the
StatusDate criteria value as =[Begin Date]. When the popup comes up asking
for the date, I enter in 9/1/08 or 9/1/2008 or 9-1-08 or and I get an msg
"Conversion Error". If I key into the criteria value =9/1/08 it works just
fine. BUT I need to use a parameter so the user doesn't have to edit the
query every time it's run.
--
Always grateful for help!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert hard coded query criteria to Parameter Query Melanie[_2_] Excel Discussion (Misc queries) 0 July 15th 08 09:59 PM
Pass date parameter into MS Query Richard Edwards Excel Discussion (Misc queries) 2 June 20th 08 11:43 AM
How to choose if I use a parameter or not in a parameter query Arnaud Excel Discussion (Misc queries) 0 March 8th 07 01:19 PM
Microsft Query: Excel, date parameter cell doesn't work. Ronco Excel Discussion (Misc queries) 5 April 27th 06 12:23 AM
MS Query Enetreing a date as Parameter Bob L. Excel Discussion (Misc queries) 0 January 5th 06 07:21 PM


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"