How to: Format a Date Field (Report Builder 1.0)
Collapse the table of content
Expand the table of content

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

  1. In design mode, select the cells containing the date values that you want to format.

  2. On the Format menu, click Number.

    The Format dialog box opens with the Number tab selected.

  3. In the Defined formats list, select a format.


    You can use a custom format by selecting the Custom format radio button and then specifying a valid Microsoft.NET Framework format string.

  4. Click OK. 

Community Additions

© 2015 Microsoft