Solved

How do I change the Dateformat in Reporting Services?

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 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