Solved

How do I change the Dateformat in Reporting Services?

Posted on 2007-12-06
1
4,459 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now