Date Format in SS Reports

Hi,

Reports created in BIDS/ Report Builder in SQL Server 2005 has the following date format:

MM/DD/YYYY 12:00:00: AM

eg: 5/26/2007 12:00:00 AM

Is it possible to create a format in SSRS (similar to the Friendly-Date format in SSAS) such that we can get date format like:

5/26/2007

Any help is appreciated.

Thanks,

Sundar

Well, I assume that you need to enter a format string in some "FORMAT" field.

Some thing like:
="dd\MM\yyyy"
|||

Yes, I did try ,fetching the date,month and year part separately and concatenating them to get DD/MM/YYYY format .

Now all the date values are Jumbled !!!

Is there any way to re-arrange them in the Calendar order ?

Thanks,

Sundar

|||

Try the following example:

Left(admitdate, 11) as Admission_Date

|||

Use this in your expression:

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

Hope this helps...

|||

Hi Deepak,

Awesome :-) is the word to describe your Suggestion !!

Its working like a Magic !!!

THANKS A LOT !!!

Cheers,

Sundar

Date Filter in Report Builder

The "On or Before" filter does not work with the 'On' part of the
filter i.e. On Or Before 30/11/2006 does not show items for 30/11/2006
but does show 29/11/2006.
Is this a bug or maybe i'm missing something.
Regards
TobiI haven't used Report Builder that much, but its possible that Report
Builder is using the format of 30/11/2006 12:00:00 (12:00 am), and your
data from the db is 30/11/2006 09:15:00 (9:15 am).
Tobi wrote:
> The "On or Before" filter does not work with the 'On' part of the
> filter i.e. On Or Before 30/11/2006 does not show items for 30/11/2006
> but does show 29/11/2006.
> Is this a bug or maybe i'm missing something.
>
> Regards
> Tobi|||I agree with Topher's assessment. If this was an actual report, I would
suggest creating an internal report parameter that adds one day and
then subtracts one second from the original parameter value. You would
then change your query parameter to use the new, internal parameter
value.
However, this is Report Builder, which I have not used much. Try to do
something like I just described.
Just had another thought... In your model, try to strip the times out.
If you aren't using them anyways, then you don't need them. If
everything has a time of 00:00:00 (12:00:00 AM), then your formula
should work just fine.
HTH,
Josh
Topher wrote:
> I haven't used Report Builder that much, but its possible that Report
> Builder is using the format of 30/11/2006 12:00:00 (12:00 am), and your
> data from the db is 30/11/2006 09:15:00 (9:15 am).
>
> Tobi wrote:
> > The "On or Before" filter does not work with the 'On' part of the
> > filter i.e. On Or Before 30/11/2006 does not show items for 30/11/2006
> > but does show 29/11/2006.
> >
> > Is this a bug or maybe i'm missing something.
> >
> >
> > Regards
> >
> > Tobi