Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
viperbyte
Posting Yak Master
132 Posts |
 Posted - 2013-06-13 : 10:30:44
|
| Good morning folks,I'm new to SSRS and am having a hard time formatting a date field. When I run my report, the date field shows results like this:20130111So I need to format it. When I right click the field and select text properties/Number/Date and select "mm/dd/yyyy", I get "mm/dd/yyyy" in the report for every row instead of a properly formatted date. Can you please teach me how to format this field? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-14 : 01:24:30
|
| the formatting works only if ase type of field is datetime. so your best bet is to bring it as date from database using CONVERT. then apply formatting in report and it should work fine------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
viperbyte
Posting Yak Master
132 Posts |
Posted - 2013-06-14 : 10:27:03
|
| Thanks visa that worked very well. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-14 : 10:46:52
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
How do I Format 20130111 Date?