In Canvas controls where a relative date and time is required, the following wildcards can be used to adjust date and time.
The T wildcard can be used to represent today. The date can be adjusted using an integer (T, T+3, T-7). The T wildcard cannot be used with component wildcards. For example:
Component wildcards can be used to describe or adjust a date and time, using the following syntax:
Component Adjustment Value
For example, d-7 H=6, will set the date and time to seven days ago (d-7) at 6:00 a.m. (H=6).
The components are case-sensitive. Date components are lowercase; time components are UPPERCASE.
| Component | Adjustment | Value | |||
|---|---|---|---|---|---|
|
y m d H M S |
Year Month Day Hour Minute Second |
- + = |
Subtract from the reference Add to the reference Equal to the reference |
Integer L or l |
Subtract from the reference Indicates last day of the month. Can only be used with the "d" (Day) component. |