Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/170739

From BetaArchive Wiki
Knowledge Base

Article ID: 170739

Article Last Modified on 4/21/2001


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q170739


When you click Parameters on the Get External Data menu, the date parameter in the "Use the following value" box of the Parameters dialog box is not formatted as a date. Instead the parameter is displayed as a value.


This behavior occurs when you do the following:

  • You use the Get External Data command and a date in a parameter query. -and-

  • In the Enter Parameter Value dialog box, you click "Use this value/reference for future refreshes."


Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.


When you use the Get External Data command, you can specify a criterion that uses a parameter query. A parameter query prompts you for an input to use in the criteria for the query. However, if the parameter query uses a date, when you store the date in the parameter by clicking the "Use this value/reference for future refreshes," the date is not displayed in a date format in the Parameters dialog box. Instead, the date is displayed as the date serial value. For example, if you enter the date June 24, 1997 in a parameter query, the date is stored in the parameter and is displayed in the Parameters dialog box as 35605.


For more information about parameter queries, click the Index tab in Microsoft Query Help, type the following text


and then double-click the selected text to go to the "Create a parameter query" topic.

Additional query words: XL97 sql access

Keywords: kbinterop KB170739