Microsoft SQL Server Links

Links, articles, scripts, tips, and other technical sources for managing SQL Server. DBALinks is dedicated to SQL Server and database administration.

CHECK OUR BLOGS!

 

 
BLOGS Minimize
Print  
 
SEARCH BLOGS Minimize

Print  
 
DOWNLOADS... Minimize
Print  
 
BOOKS... Minimize

Print  
 
Advertisement Minimize

 

Print  
 
Formatting data in Reporting Services 2005 when creting report

 

FormatDateTime function i a VBScript function the formats date or time.

Example:

= FormatDateTime(Fields!PublicationDate.Value,2)

Formats

vbGeneralDate  0  Display a date in format mm/dd/yy. If the date parameter is Now(), it will also return the time, after the date
vbLongDate  1  Display a date using the long date format: weekday, month day, year
vbShortDate  2  Display a date using the short date format: like the default (mm/dd/yy)
vbLongTime  3  Display a time using the time format: hh:mm:ss PM/AM
vbShortTime  4  Display a time using the 24-hour format: hh:mm
Permalink |  Trackback
Location: BlogsAleksandar Tosic's BlogReporting Services 2005    
Posted by: Alex Wednesday, October 15, 2008

Your name:
Title:
Comment:
Add Comment   Cancel 
 
Announcements Minimize
SQL Server Service Pack Versions - Thursday, October 30, 2008
Version @@VERSION MsDtsSrvr.exe File Version Registry Version Registry Patch Level
Release to Manufacturing 9.00.1399.00 9.0.1399.0 9.0.1399.06 9.0.1399.06
Service Pack 1 9.00.2047.00 9.0.2047.0 9.1.2047.00 9.1.2047.00
Post SP1 Cumulative Hotfix 9.0.2153.00 9.0.2153.0 9.1.2047.00 9.1.2153
Service Pack 2 CTP 9.00.3027.00 9.0.3027.0 9.2.3027.00 9.2.3027.00
Service Pack 2 9.00.3042.00 9.0.3042.0 9.2.3042.00 9.2.3042
Service Pack 2 Rollup 3 9.00.3186.0 9.00.3186.00 9.2.3042.00 9.2.3186
 

Print