format date within reporting services

The 'DD MMM YYYY' format does not work correctly when setting a default value to a date parameter! As soon as the report is previewed, the date reverts back to MM/DD/YYYY which is particularly frustrating. I know with BIDS 2005, the fix was to set the language on IIS (which seemed to override every other local setting)... so what's the fix now for Windows 7?

shelts SSChasing Mays Points: 618 More actions · Answer 5

Carolyn Richardson (1/24/2008)
There is a simpler way, by default reporting services are installed using English (United States) as the default date format adjust the Report properties language to English (United Kingdom)

Yes that works but the time portion of the date remains

Is there anyway to change the default from displaying 22/02/2012 00:00:00:00 other than going into each field as all we wish to display is 22/02/2012

Thanks

Brandie Tarvin SSC Guru Points: 172995 More actions · Answer 6

shelts (2/22/2012)
Carolyn Richardson (1/24/2008)
There is a simpler way, by default reporting services are installed using English (United States) as the default date format adjust the Report properties language to English (United Kingdom)
Yes that works but the time portion of the date remains
Is there anyway to change the default from displaying 22/02/2012 00:00:00:00 other than going into each field as all we wish to display is 22/02/2012
Thanks

You can convert it to a string and only pull out the first 10 digits. Or (in 2008) try using the Date datatype.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

bisoyi.jogeswara SSC Rookie Points: 40 More actions · Answer 7

please add this code in your expression

=Format(Parameters!FromDate.Value ,"MMMM dd, yyyy")

bisoyi.jogeswara SSC Rookie Points: 40 More actions · Answer 8

please add this code in your experssion.

=Format(Parameters!FromDate.Value ,"MMMM dd, yyyy")

j.sivashankar1987 Valued Member Points: 51 More actions · Answer 9

j.sivashankar1987

Valued Member

Points: 51

July 27, 2012 at 6:34 am

#1518452

Thanks For post so usful

ajaykd SSC Rookie Points: 47 More actions · Answer 10

Set custom format as MMMM dd, yyyy

Hope this will help.

Thanks,

Ajay

shelts SSChasing Mays Points: 618 More actions · Answer 11

Yes I know that but for each new report the date format reverts back to US with the month first. The easiest way around it I've found so far is setting the language at Report level for each new report which at least avoids the need to change it for each date field in the report set up in Report Builder!

Brandie Tarvin SSC Guru Points: 172995 More actions · Answer 12

shelts (9/28/2012)
Yes I know that but for each new report the date format reverts back to US with the month first. The easiest way around it I've found so far is setting the language at Report level for each new report which at least avoids the need to change it for each date field in the report set up in Report Builder!

This sounds like a server level language issue. Have you checked to make sure your server language / collation is set up for British or European standards and not U.S. standards?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Van Heghe Eddy SSCarpal Tunnel Points: 4449 More actions · Answer 13

shelts (9/28/2012)
Yes I know that but for each new report the date format reverts back to US with the month first. The easiest way around it I've found so far is setting the language at Report level for each new report which at least avoids the need to change it for each date field in the report set up in Report Builder!

Why not making 1 report template with the most settings right in it.

And start every new report based on this template.?

Thats the way i create my reports.

I have a standard header and footer, my language is set to Belgium locale.

So i don't have to worry about those small items all over again.

Wkr,

Eddy

Brandie Tarvin SSC Guru Points: 172995 More actions · Answer 14

Sjeef (10/3/2012)
shelts (9/28/2012)
Yes I know that but for each new report the date format reverts back to US with the month first. The easiest way around it I've found so far is setting the language at Report level for each new report which at least avoids the need to change it for each date field in the report set up in Report Builder!
Why not making 1 report template with the most settings right in it.
And start every new report based on this template.?
Thats the way i create my reports.
I have a standard header and footer, my language is set to Belgium locale.
So i don't have to worry about those small items all over again.
Wkr,
Eddy

And this is a guaranteed way to avoid the unintended consequences law that you would invoke by changing server settings.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

thepotplants Hall of Fame Points: 3079 More actions · Answer 15

Carolyn Richardson (1/24/2008)
There is a simpler way, by default reporting services are installed using English (United States) as the default date format adjust the Report properties language to English (United Kingdom)

This worked perfectly for me. Thanks!!!

I also set the format to 'd' an you get a short date 'dd/mm/yyyy'.