Using Date and Time Wildcards
In CygNet applications and dialog boxes where a date or time is required, the following wildcards can be used to describe or adjust date and time.
Today (T) Wildcards
The T wildcard can be used to represent today. The date can be adjusted using an integer (T, T+3, T-7).
Example
- T represents today at midnight
- T-1 is yesterday at midnight
- T+1 is tomorrow at midnight
Note: The T wildcard cannot be used with Component Wildcards.
Component Wildcards
Component wildcards can be used to describe or adjust a particular date and time.
Syntax
Component Adjustment Value
Example
|
d-7 H=6 |
This example sets the date and time to seven days ago (d-7) at 6:00 a.m. (H=6).
Component Options
The components are case-sensitive. Date components are lowercase; time components are UPPERCASE. The component options are the following:
| Component | Description |
|---|---|
| y | Year |
| m | Month |
| d | Day |
| H | Hour |
| M | Minute |
| S | Second (note that milliseconds are not maintained) |
Adjustment Options
The adjustment options are the following:
| Adjustment | Description |
|---|---|
| - | Subtract from the reference |
| + | Add to the reference |
| = | Equals the reference |
Value Options
The value options are the following:
| Type | Description |
|---|---|
| Integer | Subtract from the reference |
| L or l | Indicates last day of the month. Can only be used with the "d" (Day) component. |
