Date abbreviations

Last update: 2024-10-17
  • Created for:
  • User
    Admin
IMPORTANT

A new and streamlined Report Builder was released on October 16, 2024. It is supported on Mac, Windows, and web browsers.
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

On this page