Format the date
- You have until August 12, 2026 to migrate your workbooks from the legacy Report Builder to the new Report Builder. See convert your legacy workbooks for detailed information.
- With the end of life of the Adobe Analytics 1.4 API’s, the legacy Report Builder add-in will no longer be available for download.
- After August 12, 2026, customers with workbooks requiring migration will need to contact customer support to obtain the orignial workbooks. These workbooks will need to be migrated as documented in convert your legacy workbooks.
In addition to the standard cell formatting choices available through Excel’s Format > Cells (Ctrl+1) feature, you can apply limited formatting to cell ranges with Report Builder. These formatting choices depend on the metric you have chosen.
After you add dimensions to the Row Labels grid, click Format.
In the Format menu, click Custom Format to apply customized formats for dates similar to the prepend and postpend feature. For example, you can enter text that always occurs after the date (such as A.D. B.C.E. A.H. etc.). You can add text before the date, such as Start Date and Start and End Date. In addition, you can construct a custom date expression from day, month, and year abbreviations, and use a custom separator between parts of the date. All date formats must consist of three abbreviations only enclosed in brackets.
The following table describes how you can use date abbreviations in the Custom Format field: