SSRS 2005 Date Formats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 29 Mar 2006 15:05 GMT

I am having problems with date formats in report manager. I am in the UK and
want the dates displayed as dd/mm/yyyy. When I enetr the date in the
parameter field it changes the month and day around and if I try to enter any
number above 12 an erro is given. It ia also not picking up the correct date
parts when using the day or month function. Any idea ho to solve these
problems?

Reply to this Message

Ed Allison - 29 Mar 2006 15:44 GMT

Hi Dan,

What follows is based on SSRS 2005

I ran into this kind of problem a lot a while ago.

Firstly, is the Language property on your report correct. The default is
English(United States).

Secondly, whilst the above will fix the problem in the report manager, when
testing the report in BIDS or VS, you still have to enter the date in US
format. Since the Language setting fixes the problem for me when the report
is deployed to the report server, I do not worry about this too much.

I hope this helps,

Ed.

>I am having problems with date formats in report manager. I am in the UK
>and
[quoted text clipped - 5 lines]
> parts when using the day or month function. Any idea ho to solve these
> problems?

Reply to this Message

Amarnath - 31 Mar 2006 06:42 GMT

Hi,

Just refer the format functions syntax you should be able to do the date
formating.
e.g. Format(today, "dd/MM/yyyy") watch out for case sensitive... It is very
important since mm means milliseconds and MM means month.

Amarnath.

> Hi Dan,
>
[quoted text clipped - 23 lines]
> > parts when using the day or month function. Any idea ho to solve these
> > problems?

Reply to this Message