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.

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'

I think you can specify a cell format. – ta.speot.is Feb 04 '12 at 11:56 — ta.speot.is, Feb 04 '12 at 11:56
@todda.speot.is Thanks. But how i specify? – Sagotharan Feb 04 '12 at 12:13 — Sagotharan, Feb 04 '12 at 12:13

score 28 · Accepted Answer · answered Feb 04 '12 at 12:22

28

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

answered Feb 04 '12 at 12:22

nemesv

138,284
16
416
359

score 1 · Answer 2 · answered Sep 04 '17 at 08:57

1

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

answered Sep 04 '17 at 08:57

Ajay Dagade

91
1
1

1

Can you elaborate on our answer and explain why yours is better than the ones already provided? – Noel Widmer Sep 04 '17 at 09:27

score 0 · Answer 3 · answered Mar 16 '17 at 05:30

0

This worked for me:

=FormatDateTime(Now(), DateFormat.ShortDate)

answered Mar 16 '17 at 05:30

Talha Imam

1,046
1
20
22

score 0 · Answer 4 · edited Sep 13 '19 at 10:31

0

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

The image shows the working of dateFormat.

The image shows the working of dateFormat

edited Sep 13 '19 at 10:31

4b0

21,981
30
95
142

answered Sep 13 '19 at 10:29

Riya Ashfaque Ahamad

1
1

score -1 · Answer 5 · answered Feb 14 '13 at 07:36

-1

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

answered Feb 14 '13 at 07:36

chirag

39
4

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

5 Answers5

Linked