URGENT: date parameter and regional location

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

  1. news

    news Guest


    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. 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
    1. Advertisements

  3. news

    news Guest

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

    srinivas Guest


    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, Mar 17, 2005
    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.