SSRS DateFormat

Question

Hi,

 

I am having the ReportDate='1998-12-31 00:00:00.000'

 

I need in the format 'mm/dd/yy hh:mm AM/PM'

 

can you please tell me the Expression for this format.

 

Thanks

Dinesh

Answer 1

It is best practice to use one of the format codes.

Right click - properties on the cell, select format, click "...", and you can see the date formats from there. This will be converted into a date code when you OK the dialog.

If you use this in conjunction with having the property Report Language set to User!Language, then your users will see the date in the format that suits them
e.g. 31/12/2001 vs 12/31/2001 vs 31.12.2001

Answer 2

hii

The format for the date field as "mm/dd/yy hh:mm AM/PM" is as follows

=Format(Parameters!To_Timeframe.Value,"MM/dd/yyyy" & " " & "h:mms tt")

(the parameter!to_timeframe.Value can be the value of any date field,i just gave it for example)

This will work fine.

Thanks

Mahasweta

 

 

 

 

 

 

 

 

 

 

 

Answer 3

Hi,

 

You can use the Format function for this. http://msdn2.microsoft.com/en-us/library/8kb3ddd4(VS.71).aspx have a look at this link.

It gives you details of all the formating options.

 

 

Thanks

Virendra

 

Answer 4

Hi,

 

    I tried the below format

Format(Fields!Survey_Mailed_Date.Value,"MM/dd/yy" & " " & "h:mms tt")

 

but in report it is displaying as "MM/dd/yy h:mms tt"

 

When i used this in the header section like below it returns the correct result

Format(Now,"MM/dd/yy" & " " & "h:mms tt")

 

 

Thanks

Dinesh

 

Answer 5

Hi,

 

   My problem is solved.

 

   SSS is a datetime. before i was not converted into datetime after converting it is working

 

   Here the below syntax is used to display date like "03/12/07 09:27 AM"

 

=Format(Cdate(Fields!SSS.Value),"MM/dd/yy " & " " & "hh:mm tt")

 

 

Thanks

Dinesh

 

Answer 6

Here are some date formats, which helps you.

http://praveenbattula.blogspot.com/2010/01/date-formatting-in-sql-server-reporting.html

---

ASP.NET and SharePoint developer
Company: http://www.rampgroup.com/
Blog: http://praveenbattula.blogspot.com