Date abbreviations

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