Date/Time Shortcuts
Important: You do not have the latest version of Historian! You are missing out on the newest capabilities and enhanced security. For information on all the latest features, see the Historian product page. For more information on upgrades, contact your GE Digital sales agent or e-mail GE Digital Sales Support. For the most up-to-date documentation, go here.
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.