I am doing this to format the date but it is not applicable .

I am doing this to format the date but it is not applicable . Hello John, Can you please explain what you mean / whats not applicable? See also MSDN: Formatting Numbers and Dates (Report Builder and SSRS)Olaf Helper Blog Xing

I want to format date like 23 July 2012 . How I can do this either design level or query level ?

By using the Format property of the TextBox together with eighter "User-Defined Date/Time Formats (Format Function)" or "Predefined Date/Time Formats (Format Function)" See also SQL Server Reporting Services (SSRS) Formatting CodesOlaf Helper Blog Xing

Hi John, Just as Olaf posted above, you can use Format() function to get the expected date format. In your case, please refer to the following expression: =Format(Fields!StartDate.Value,dd- MM- yyyy). (Note: the format characters are case-sensitive) The following screen shot shows how to set the property of the textbox, please take as reference. Regards, Fanny Liu Fanny Liu TechNet Community Support

format the textbox as this - d MMMM yyyy or =Format(Fields!StartDate.Value,"d MMMM yyyy")Think out of the box