Reporting Services Date Paramater Format Problem

Question

Reporting Services Date Paramater Format Problem

Paul Ingham

SSC-Addicted

Points: 424
More actions
October 30, 2007 at 5:31 am

#178901

HI
I have a developer that has a SSRS2005 report that uses a date parameter, when displayed through the Reports Manager URL the date picker is in UK format and the report runs fine, but when it runs through the report server the date picker uses US format and the report errors. I have set everything i can find to en-gb but still no luck.
Has anyone else come across this or has a solution, the only one i can now think of is to use seperate picklists for the Day, Month and Year!
Cheers,
Paul :w00t:

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

gavin-538865 Valued Member Points: 55 More actions · Answer 1

You mean this problem? I am not satisfied with the answer on the thread, but it does pretty much confirm the need to have separate year, month, and day drop downs.

dva2007 SSCertifiable Points: 7707 More actions · Answer 2

Hi,

You can change date format by writing following expression.

DatePart("d",Parameters!startdate.Value) & "/" & DatePart("m",Parameters!startdate.Value) & "/" & DatePart("yyyy",Parameters!startdate.Value) & " and " & DatePart("d",Parameters!enddate.Value) & "/" & DatePart("m",Parameters!enddate.Value) & "/" & DatePart("yyyy",Parameters!enddate.Value)

Pleaes change parameters!startdate.value to your appropriate field. If it is parameter then you need to change startdate field. If it is particular fields then you can change it accordingly.

Hope this helps.

Vijay

Patrick.I Hall of Fame Points: 3105 More actions · Answer 3

I'm having the same issue.

Can you explain where i would have to put that code?

The calendar is displaying dates in american format i want it in Asutralia format.

I have set the Report language property to en-AU.

The regionla setting on my pC is also in Australia..

Please elaborate

Thanks

Patrick.I Hall of Fame Points: 3105 More actions · Answer 4

Fixed it and blogged it here:

http://geekswithblogs.net/naijacoder/archive/2008/06/26/123422.aspx

dlear SSC Rookie Points: 27 More actions · Answer 5

Vijay

Thank you I was able to use part of your code to fix a problem I was having 🙂

Patrick.I Hall of Fame Points: 3105 More actions · Answer 6

Patrick.I

Hall of Fame

Points: 3105

June 8, 2009 at 6:18 pm

#1006372

Goo to know that

dva2007 SSCertifiable Points: 7707 More actions · Answer 7

dva2007

SSCertifiable

Points: 7707

June 9, 2009 at 1:47 pm

#1007027

glad you are sorted.