How to remove time and display date only in RDLC

all I use Winform (C #) and MySQL RDLC. In this, I am trying to show the date only in Tablex.

But this date format also has time. How to remove time.

My expression is ..

=Fields!date.Value

See my report below.

enter image description here

Thanks in advance?

I tried = Fields! date.Value.ToString ("dd / MM / yyyy") in the expression But this is due to an error, .. Error 1 An error occurred while checking. HRESULT = '8000000A'

+5
source share
4 answers

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

+18
source

This worked for me:

=FormatDateTime(Now(), DateFormat.ShortDate)
0
source

= " : -" & (, "dd/MM/yyyy hh: mm tt" )

0

(Fields! Date.Value, "//" )

-1

All Articles