Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Mar 2006
    Posts
    76
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Excel Web Data Query - Parameter problem

    Hi all, i have an web data query, where the parameter I need to change weekly - is a date in the intranet web address (formatted as yyyy-mm-dd).

    I aim the query's [] parameter to the date cell, excel's formula bar still shows the date as m/dd/yyyy and the data query won't work. I think this is causing the problem .

    Does anyone on have a suggestion on how to get the query to recognize a date in the (yyyy-mm-dd) format i need?

    Thanks for any assitance you can provide!

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Unome,

    In VBA you could use this: =format(A1,"yyyy-mm-dd")

    In the workbook you can use a custom format:
    customdate.JPG

    If the custom format doesn't work you can use a helper cell with this formula:
    =TEXT(A1,"yyyy-mm-dd")
    Then point your query to that cell.

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    zeddy (2015-04-12)

  4. #3
    Star Lounger
    Join Date
    Mar 2006
    Posts
    76
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Genius, the TEXT Helper cell worked like a charm!!! Thank you sooo much for this great idea!

  5. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi RG

    For Genius, you deserve thanks.

    zeddy

  6. #5
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Zeddy,

    Thanks but let's not abuse the system.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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