asked on

SSRS date parameter format

I have a SSRS report which include a date parameter.

I am in England and I want to see the parameter date picker output default to the English date format dd/mm/yyyy.

How can I do this?

aelliso3

Unfortunately, you cannot ... at least not without using a custom front-end (like asp) or something that can alter the XML at runtime. SSRS does not have this functionality available.

Mr_Shaw

ASKER

Sorry...

I should say that I am still working in the BIDS enviroment.

Another person in the office who is also using BIDS is able to select the data using the English format.

There must be a setting to change?

aelliso3

I totaly misunderstood what you were asking ...
Try going to the properties window for the the report and changing the Language setting to 'en-US'

ASKER CERTIFIED SOLUTION

AntonyDN

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mr_Shaw

ASKER

i'll just reboot

Mr_Shaw

ASKER

Why do you think it works on another computer but not mine?

SOLUTION

aelliso3

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

AntonyDN

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Howard Cantrell

where you are showing the parameter date in the report.....
all you have to do is use format.
example: =Format(Parameters!StartDate.Value, "dd/MM/yyyy")

SOLUTION

aelliso3

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Howard Cantrell

this can also be setup in the expression area of the parameters properties
=Format(Parameters!StartDate.Value, "dd/MM/yyyy")

Mr_Shaw

ASKER

Thanks for the help...