When you create a client report definition (RDLC) layout for a report, you must modify date values so that they are formatted correctly. Use the following procedure to verify or change the format of a date.
Before you begin this procedure, you must create a layout suggestion for the report. For more information, see How to: Create a Layout Suggestion.
To format date values
-
In the Classic client, on the Tools menu, click Object Designer.
-
In Object Designer, click Report, select a report that you want to modify, and then click Design.
-
On the View menu, click Sections.
-
Right-click the text box that displays a date, and then click Properties.
-
In the Properties window, in the SourceExpr field, change the date value to FORMAT(<date value>).
-
In the Properties window, in the Caption field, enter the value for the caption of the variable.
-
On the File menu, click Save.
-
In the Save window, select the Compiled check box, and then click OK.