Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show all characters in a date 1

Status
Not open for further replies.

ynnepztem

Programmer
Aug 2, 2001
54
US
How do I format a field on a SQL Server Reporting Service report to show all of the characters in a date. For January 5, 2008 I get 1/5/2008. I want to show 01/05/2008. The data type in the SQL Server 2005 database is SmallDateTime. Thanks for your help.

Penny
 
right click the box the date field is in and select properties. Then go to the Format tab and enter
Code:
MM/dd/yyyy
into the "Format code:" field.

"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top