I have a datefield with ssrs 2005... that i would like to format...I know how to format the date which is FORMAT(field, "dd/MM/yyyy") but how do i do the time also? is it dd/MM/yyyy HH:mm:ss

=Format(Fields!myDateTime.Value, "M/d/yyyy h:mmtt") ... 6/15/2009 2:45PM =Format(Fields!myDateTime.Value, "MM/dd/yy HH:mm") ... 06/15/09 14:45Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hallo SQL_1980, yes - it is "dd.MM.yyyy hh:mm:ss" Get more details about the possibility of formats for datetime in RS in http://thavash.wordpress.com/2007/10/02/date-formatting-in-reporting-services-list-of-format-codes/ HTH...Uwe Ricken MCIT Database Administrator 2005 MCIT Database Administrator 2008 MCTS SQL Server 2005 MCTS SQL Server 2008, Implementation and Maintenance db Berater GmbH http://www-db-berater.de