Solved

How do I change the Dateformat in Reporting Services?

Posted on 2007-12-06
1
4,487 Views
Last Modified: 2013-11-26
I´m trying to use the datepicker in a report in Reporting Services. I want dates on the format dd-MM-yyyy and in a way I have succeded, the problem is I have to click the View Report button twice to get the result. First click MM-dd-yyyy next click dd-MM-yyyy. Does anynone have any idea how I can skip the first click? I've tried to ask this question before but didn't get any answer, I´m new to this website and maybe I'm doing something wrong.

Open in new window

0
Comment
Question by:sigurdur66
1 Comment
 
LVL 8

Accepted Solution

by:
sjturner2 earned 500 total points
ID: 20495508
To set the date format in SSRS you have to set the language of the report, chnage the language to 'English (United Kingdom)'.

This blog may help:
http://bobp1339.blogspot.com/2007/10/multi-language-tips-in-ssrs.html 
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question