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.

   📘

   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}).