Formatting dates in Report Writer reports

To format dates in Report Writer reports, do the following:

  1. Right-click the cell with the date, then choose Format Cells.
  2. Click the Date category.
  3. Choose the desired format from the list.

    4. Note: For information about each Date/Time Format, see Date Functions.

    Formatting date/time cells

  4. Click Okay.

If you are using a formula, open the Formula Editor (Right-click cell > Edit Formula) and use the DateCustomFormat function.

Using the Formula Editor

To make sure the date respects the user's browser language for date formats, use the formula GlobalDateFormat or GlobalDateTimeFormat.

Example: GlobalDateFormat({Payments.PaymentDate}).