How to remove the time and Display the Date only in RDLC

c# winforms rdlc
Sagotharan picture Sagotharan · Feb 4, 2012 · Viewed 28.2k times · Source

all I am using Winform(C#) and RDLC MySQL. In that I try to show the date only in Tablex.

But this date format have time also. How to remove the time.

My Expression is,..

=Fields!date.Value

See my report below.

enter image description here

Thanks in advance?

I am tried =Fields!date.Value.ToString("dd/MM/yyyy") in expression But It through error,.. Error 1 An error occurred while validating. HRESULT = '8000000A'

Answer

nemesv picture nemesv · Feb 4, 2012

You can use the FormatDateTime method:

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

Or you can set the formatting in the properties window: enter image description here

Related questions

How to set parameter values in RDLC

I have added two text boxes for the date range in the report. To fill the values in the text boxes, I set parameters to the text boxes. Now the date range is coming from a form named DateRange having …

Read More
How to refer to the value of a textbox in an expression window (Local Report)?

The expression window doesn't need to be the expression window you can open by right-clicking the textbox -> choosing Expression. A textbox has some expression windows which are Font-related expression windows, Alignment-related expression windows, Visibility-related expression window,Border-related expression …

Read More
How do I make a textbox that only accepts numbers?

I have a windows forms app with a textbox control that I want to only accept integer values. In the past I've done this kind of validation by overloading the KeyPress event and just removing characters which didn't fit the …

Read More