Report Design (rdlc) - how to format a date string

Question

User-939424565 posted

I am in Report Design. I have a textbox that is reading a DateTime field from SQL 2005 database. The textbox has the following expression when I first put it on to the Report Designer:  =First(Fields!BatchCreateDate.Value, "BatchDAL_Batch_Table").

The output on the webform looks like this: 1/18/2009 3:51:00 PM

What I want is for it to look like this: Jan 18, 2009

Where do I format the expression? I tried putting this in the Format Property: =DateString("MMM dd, yyyy) but this did not change anything.

Answer 1

User1674611532 posted

In the report (rdlc) ,

Right Click in the Field, select properties,

Select the Tab Format, and use the format code you need. 

d	Short date
D	Long date
t	Short time
T	Long time
f	Full date/time (short time)
F	Full date/time (long time)
g	General date/time (short time)
G	General date/time (long time)

Javier

 

Please do not forget to mak it Answer it.

 

 

 

Answer 2

User1674611532 posted

In your case use:

MMM dd, yyyy

 Javier

Answer 3

User119618378 posted

Thanks javier it really works well.

i have used the following for showing date and time in 24 hours format:-

         dd-MM-yy HH:mm

 

 

Answer 4

User-2111753889 posted

Thanks a lot for the information

Answer 5

User1163656830 posted

Dear,

Try Following:

In the expression window of Text Box:

=Cdate(First(Fields!BatchCreateDate.Value, "BatchDAL_Batch_Table").Month) & " " & Cdate(First(Fields!BatchCreateDate.Value, "BatchDAL_Batch_Table").Day) & "," & Cdate(First(Fields!BatchCreateDate.Value, "BatchDAL_Batch_Table").Year)

This will work/././.

 

Answer 6

User827344553 posted

Thank you very much for this information, it just solved my challenge.

Happy New Year everyone in this forum 

Answer 7

User1505188413 posted

Hi.

I just have run in same problem, 

and solution i like is : 

=CDate(First(Fields!DateFrom.Value, "dataReport")).ToString("dd.MM.yyyy")

Point is, when you convert to date with CDate, you have DateTime instance where you can perform formation as you wish.

Something similar is for decimal, double.... etc.

Answer 8

User-1089808927 posted

It work in Local succes

but it work in server