Jaa


How to: Format a Date Field (Report Builder)

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 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.

    Note

    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.

See Also

Tasks

How to: Format a Number Field (Report Builder)

Concepts

Formatting Numerical Data (Report Builder)

Other Resources

Format Dialog Box (Number Tab) (Report Builder)

Help and Information

Getting SQL Server 2005 Assistance