Date/Time Shortcuts
The following table outlines the date/time shortcuts that you can use in calculation formulas.
| Shortcut | Description |
|---|---|
| Now | Now (the time and date that you execute the query) |
| Today | Today at midnight |
| Yesterday | Yesterday at midnight |
| BOY | First day of year at midnight |
| EOY | Last day of year at midnight |
| BOM | First day of month at midnight |
| EOM | Last day of month at midnight |
Relative Date/Time Shortcuts
Optionally, you can add or subtract relative times to the following absolute times.
You must use them in conjunction with the date/time shortcuts listed in the
preceding table (for example, Today+5h+3min instead of 5h3min).
- Second
- Minute
- Hour
- Day
- Week