Date/Time Shortcuts
The following table outlines the date/time shortcuts that you can use in calculation formulas. If Historian accepts an abbreviation for the shortcut, in addition to the full shortcut, the abbreviation appears in bold in the following table.
| 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 absolute times listed in the following table. The following table outlines the relative time shortcuts. If Historian accepts an abbreviation for the shortcut, in addition to the full shortcut, the abbreviation appears in bold in the following table.
| Shortcut | Description |
|---|---|
| Second | Second |
| Minute | Minute |
| Hour | Hour |
| Day | Day |
| Week | Week |
Note: You cannot write a shortcut as 5h3m. Instead, you can write this shortcut as: Today+5h+3min.