CODEWITHSUNDEEP
reporting-servicesssrs-2008
nojla
nojla

Reputation: 435

SSRS FormatDateTime

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

Upvotes: 2

Views: 9343

Answers (3)

Patch
Patch

Reputation: 19

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.

Upvotes: 0

chixco
chixco

Reputation: 53

Try this: 

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

Upvotes: 3

Henrov
Henrov

Reputation: 1610

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.

Upvotes: 2

Related Questions