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

Show expandable text

We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

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")]

Was this article helpful?

Thank you for the feedback!