SSRS FormatDateTime

Question

Im using =FormatDateTime(Parameters!StartDate.Value,DateFormat.ShortDate) and its returning "mm/dd/yyyy" format.

I want to return it in this format "dd/MM/yyyy". Please help how to do it!

Thanks

Have you looked at http://stackoverflow.com/questions/15975955/how-do-i-format-date-and-time-on-ssrs-report ? — Ian Preston, Oct 17 '14 at 17:00
possible duplicate of [SQL reporting services report not showing date in correct format](http://stackoverflow.com/questions/1540948/sql-reporting-services-report-not-showing-date-in-correct-format) — Chris Latta, Oct 18 '14 at 11:27

score 3 · Answer 1 · edited Nov 23 '14 at 22:44

3

Try this:

=Format(Parameters!StartDate.Value,"dd/MM/yyyy")

edited Nov 23 '14 at 22:44

StackExchange What The Heck

2,656
7
39
51

answered Nov 23 '14 at 21:30

chixco

53
6

score 2 · Answer 2 · answered Oct 20 '14 at 13:53

2

Click on the reportcanvas, Press F4. Now you get the properties of the report. There is a property called 'language'. Choose the appropriate setting, for example NL_nl if you want dutch notation.

answered Oct 20 '14 at 13:53

Henrov

1,610
1
24
52

score 0 · Answer 3 · answered Apr 21 '15 at 08:55

0

Can't vote up/down due to an inadequate rep but the correct answer is that provided by henrov. In my case, it involved setting the language to en-GB.

I did, however, have to quit SSRS; delete the compiled reports; relaunch SSRS and recompile before the change could be seen in the preview window.

answered Apr 21 '15 at 08:55

Patch

19
1

Just add a comment below the answer you want to upvote, adding another "empty" answer is unhelpful. – A. Rama Apr 21 '15 at 09:14
Cheers for the -1; that helps my rep even more. At least I now know the correct link to click. – Patch Apr 21 '15 at 13:43
You can also delete the *.rdl file and preview the report again. You won't get cached results then and don't have to quit VS. – Josh Alvo May 12 '15 at 11:50

SSRS FormatDateTime

3 Answers3