How I can format date in report to appear exactly as I want - RDLC

visual-studio-2010 reporting-services rdlc report
Saleh picture Saleh · Feb 17, 2011 · Viewed 43.4k times · Source

I have a report in my application and this report will show a long date from db and I used this expression to make it shorter:

=FormatDateTime(Fields!StatementDate.Value,DateFormat.ShortDate)

and the date will show like this : 1/1/2010

I need to make it like this : 2010/1/1

How I can do it?

Answer

pcofre picture pcofre · Feb 18, 2011

That expression do the trick

=CDate(Fields!Fecha.Value).ToString("yyyy/M/d")

Related questions

RDLC - Adding a Data Source in VS2010

Greetings. I have an RDLC file and am wanting to add a data source to it, although without any luck so far. The data source is a custom class written by myself (just to add, we do this all the …

Read More
How do you create a report (rdlc) that shows 1 record per page

Having some trouble getting this to work... I basically want the report to look similar to: The way I remember doing this in the past was by creating "page groups" in the report wizard. However, I believe that was in …

Read More
Visual Studio 2010 RDLC: Support for HTML?

I've read rumors that with the Report Viewer component of Visual Studio 2010 Professional, it is possible to render HTML from the database into a report. Unfortunately, I wasn't able to find definite information online and I'd rather not buy the …

Read More