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