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

Question

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.

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'

Metacarpus

I think you can specify a cell format. – Pallmall

@todda.speot.is Thanks. But how i specify? – Metacarpus

Answer 1

You can use the FormatDateTime method:

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

Or you can set the formatting in the properties window:

Wafd

Answer 2

="Current Date:-"&Format(Now,"dd/MM/yyyy hh:mm tt") this is for current date and time

Confident

Can you elaborate on our answer and explain why yours is better than the ones already provided? – Anselmi

Answer 3

This worked for me:

=FormatDateTime(Now(), DateFormat.ShortDate)

Cragsman

Answer 4

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

The image shows the working of dateFormat.

Uganda

Answer 5

formate(Fields!date.Value,"dd/MM/yyyy")

Subterrane