URGENT: date parameter and regional location

Discussion in 'microsoft.public.sqlserver.reportingsvcs' started by news, Mar 5, 2005.

  1. news

    news Guest

    Hi,

    I have a report with startdate as a string report parameter formatted
    MM/dd/yyyy. It works fine on the computer with regional setting to English
    (United Stated) where its date formatted as MM/dd/yyyy. However, the report
    parameter changes to dd/MM/yyyy on another computer with regional setting to
    English (United Kingdom) where its date formatted as dd/MM/yyyy. The query
    to SQL server fails since the date is invalid. How can I fix this? Thanks.
     
    news, Mar 5, 2005
    #1
    1. Advertisements

  2. Is the parameter data type set to date / time? If so, it should work no
    matter what the locale is. If you want it to be a specific one, set the
    language of the report to the one where you want.

    --
    Brian Welcker
    Group Program Manager
    Microsoft SQL Server Reporting Services

    This posting is provided "AS IS" with no warranties, and confers no rights.
     
    Brian Welcker [MSFT], Mar 5, 2005
    #2
    1. Advertisements

  3. news

    news Guest

    Thanks, I changed it to datetime and it works fine.
     
    news, Mar 5, 2005
    #3
  4. news

    srinivas Guest

    Hi,

    I'm facing the same problem with the dateformats.

    I've set the datatype for the report parameter to Datetime. But still
    getting the error.

    When I try to pass the date in dd/mm/yyyy ( say 16-02-2005) it's woking fine.

    But if I change it to 02-16-2005, it's not working. But as you said it
    should work in any case.

    Please let me know how to solve it.

    srinivas
     
    srinivas, Mar 17, 2005
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.