The following will prove useful as these dynamic dates can be typed in nearly any date field in CT3.

The comprehensive options with entering dates are as follows:

  • Quick shortcuts:
    • -” yesterday
    • +” tomorrow
    • .” or “T” today
  • Date parsing according to current computer settings:
    • January 2, 2019” or “1/2/2019” would be January 2nd in the US (February 1st in Canada)
  • Hyphens:
    • 2019-01-02” or “01-02-2019” would be January 2nd in the US (February 1st in Canada)
  • Numbers only:
    • 04” or “4” would be the 4th day of the current month and year
    • 0102” would be January 2nd of the current year
    • 010218” or “01022018” or “20180102” would be January 2nd of 2018
    • 01218” and “0122018” also parse out to January 2nd but the goal is to catch the user error of not using a 2-digit day
  • Arithmetic:
    • -4”, “-3”, “-0” yields that number of days in the past. For example “-1” is yesterday and “-7” is a week ago
    • +4”, “+3”, “+0” yields that number of days in the future. For example “+1” is tomorrow and “+7” is a week from now
    • End of month (executed in December 2019):
      • MonthEnd-0” end of current month: 12/31/2019
      • MonthEnd-2” end of month two months ago: 10/31/2019
      • MonthEnd+2” end of month two months from now: 02/29/2020
    • Start of month (executed in December 2019):
      • MonthStart-0” start of current month: 12/01/2019
      • MonthStart-2” start of month two months ago: 10/01/2019
      • MonthStart+2” start of month two months from now: 02/01/2020
    • Relative weekdays:
      • Sunday-0” for this Sunday and “Sunday-1” for last Sunday.
      • Sunday-1”, “Sun-1”, “Su-1” with any weekday name gets that day of the week relative to today, with “-0” equating to when we would say “this”, and “-1” meaning last week, “-2” meaning two weeks ago, etc.
      • Examples (using Thursday 12/05/2019 as the current date):
        Sunday-0” yields 12/08/2019 (“this Sunday”) as Sunday is the last day of week by default
        Thursday-0” yields 12/5/2019 (“this Thursday” is taken to mean “today”)
        Thursday+1” yields 12/12/2019 (“next Thursday”)
        Saturday+1” yields 12/14/2019 (“next Saturday”)

 

Day names:

Sunday

Sun

Su

Monday

Mon

Mo

Tuesday

Tue

Tu

Wednesday

Wed

We

Thursday

Thu

Th

Friday

Fri

Fr

Saturday

Sat

Sa