Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    4

    Question Unanswered: Parameters - MS Query

    I'm trying to set up a parameter in MS Query (to dump data into excel via ODBC). I can do it for all data types except dates. No matter what I do, when I try to use a parameter for a date field, I get the following message:

    Illegal data: '{tx '20'. Expected format: 'Default Datetime Mask'

    Anyone have any experience with date type parameters?

  2. #2
    Join Date
    Nov 2004
    Posts
    108
    have you tried using "yyyymmdd" format

    I think the date should be between single quotes

  3. #3
    Join Date
    Nov 2004
    Posts
    4

    Angry

    I tried that. Still no luck.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •