DocumentationAnalyticsTools Guide

Date abbreviations

Last update: Thu Oct 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User
  • Admin
IMPORTANT
A new and streamlined Report Builder is available since October 16, 2024. This Report Builder is supported on macOS, Windows, and web browsers and can be used with Adobe Analytics and Customer Journey Analytics.
This Legacy Report Builder add-in version still works. You can convert your legacy workbooks to the new Report Builder.

Time abbreviations refer to a particular date when a period begins, not a range of days. A range of days is expressed by specifying a start and an end date for two time abbreviations or terms.

For information about using proper syntax, see Syntax Notes.

  • cd = current date (today)
  • cw = current week (first day of the current week)
  • cm = current month (first day of current month)
  • cq = current quarter (first day of current quarter)
  • cy = current year (first day of current year)

In the following list, [UNIT] indicates any integer multiplier.

  • [UNIT] d = day
  • [UNIT] w = week
  • [UNIT] m = month
  • [UNIT] q = quarter
  • [UNIT] y = year
recommendation-more-help
a83f8947-1ec6-4156-b2fc-94b5551b3efc