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 |