Last post Sep 13, 2011 01:43 AM by Rajrocks
Jan 24, 2009 02:48 PM|jfeeney|LINK
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,
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.
Jan 24, 2009 04:04 PM|Javier Fuentes|LINK
In the report (rdlc) ,
Right Click in the Field, select properties,
Full date/time (short time)
Full date/time (long time)
General date/time (short time)
General date/time (long time)
Please do not forget to mak it Answer it.
Jan 24, 2009 04:23 PM|Javier Fuentes|LINK
In your case use:
MMM dd, yyyy
Feb 18, 2009 03:29 AM|synthesys|LINK
Thanks javier it really works well.
i have used the following for showing date and time in 24 hours format:-
Aug 20, 2009 05:52 AM|sumanm2412|LINK
Thanks a lot for the information
Aug 17, 2010 03:19 AM|nuclione.systems|LINK
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,
This will work/././.
Jan 25, 2011 09:48 AM|bioscom|LINK
Thank you very much for this information, it just solved my challenge.
Happy New Year everyone in this forum
Jan 28, 2011 08:54 AM|vllado2|LINK
I just have run in same problem,
and solution i like is :
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.
Sep 13, 2011 01:43 AM|Rajrocks|LINK
It work in Local succes
but it work in server