UK Date Format in Report Parameter Date Picker

• piet_dj

  Old Hand

  Points: 378

  More actions

  April 17, 2008 at 6:18 am

  #205982

  Hi All,

  I have setup a report with two parameters, a start and an end date. This works as intended, however, the drop down date list in the report manager shows dates in the following format:

  MM/DD/YYYY HH:MM:SS

  I would like this drop down menu to display dates in the format like this (UK):

  DD/MM/YYYY

  I have changed the report language to UK but this doesn't fix it. Any ideas what I should be doing? Ideally without converting the dates to varchar in the query?

  Thanks in advance

• piet_dj

  Old Hand

  Points: 378

  More actions

  April 17, 2008 at 8:40 am

  #803769

  I should specify, that my drop down list of dates is exactly that, NOT a date picker which I would like to achieve with UK date format.

  I am using SSRS 2005, with SP2 installed.