Hi, This is Sahu i have a one doubt how to give the date foemat syntax in ssrs reports Thank you

"2010-18-05" : Format(CDate(dateEx), "dd/MM/yyyy")Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

give me one example

Hi, You can format dates using various built in functions in ssrs. Below are some examples. Format(Fields!myDate.Value, “M/d/yy”) - 2/11/08 Format(Fields!myDate.Value, “MM/dd/yyyy”) - 02/11/2008 Format(Fields!myDate.Value, “d-MMMM-yy”) - 11-December-08 Format(Fields!myDate.Value, “d-MMM-yyyy”) - 11-Dec-2008 Format(Fields!myDate.Value, “M/d/yyyy H:mm”) - 2/11/2008 13:50 Format(Fields!myDate.Value, “MMM-dd-yyyy”) - Feb-11-2008 Click the below link and see the Date functions section for more details. http://msdn.microsoft.com/en-us/library/ms157328.aspxMSBI Developer