How to: Format a Date Field (Report Builder 1.0)
Using the Number tab on the Format dialog box, you can select from a variety of date and date/time format options. In addition to the options available, you can choose to customize the formatting by using a valid Microsoft .NET Framework format string. For more information about valid .NET Framework format strings, see "Numeric Format Strings" on the Microsoft Developer Network (MSDN).
To format date values
In design mode, select the cells containing the date values that you want to format.
On the Format menu, click Number.
The Format dialog box opens with the Number tab selected.
In the Defined formats list, select a format.
Note
You can use a custom format by selecting the Custom format radio button and then specifying a valid Microsoft.NET Framework format string.
Click OK.