Report Designer: Adding a prior-period variable to a letter

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

You can use the Date function in the Report Designer to display a date in a letter other than the current period end date.

  1. Choose File > Report Designer.
  2. In the Reports list frame of the Report Designer, click the Letters button and then double-click a letter to open it in the design grid.
  3. Place your cursor in the letter where the date is to be placed.
  4. Choose Insert > Formula.
  5. Click the Functions option at the top of the dialog.
  6. Highlight the Date row in the list.
  7. Click the Variable Variable button button next to Variable 1 field to open the Variables dialog.
  8. Select the System.FinancialStatement.PeriodEndDate variable in the tree and click OK.
  9. Click the Ellipsis  button next to the Date format field in the Formula dialog and choose the appropriate date format and click OK.
  10. Click the calendar button next to Period field and select the appropriate period.
  11. Click OK.

Example: The following date formula can be inserted into the letter to display the four digit year of the prior year.

[Date(System.FinancialStatement.PeriodEndDate,"yyyy","1PY")]

See also: Report Designer: Procedures

Share This