Formatting dates in Report Writer reports

Important! Report Writer displays dates in English or Spanish only. Date translation to other languages is not supported by the underlying report engine.

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.

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



4. Click Okay.

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

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

Example: GlobalDateFormat({Payments.PaymentDate}).