Runtime keywords can be used in the selection criteria of any report, either listed as a literal term, or used at a prompt.
Use the date keywords below in your selection criteria. (+/- n) means days before or after the keyword. You may also use (+/- nM) to mean months before or after the keyword. For example, TODAY – 7 evaluates to seven days prior to the current day. To specify one month in the future, use TODAY + 1M.
| Keyword | Meaning |
| TODAY (+/-n) | Will put the value of the date the report is run (plus or minus n number of days). |
| WEEK_BEGIN (+/-n) | Will put the value of the date of the beginning of the week the report is run. |
| WEEK_END (+/-n) | Will put the value of the date of the end of the week the report is run. |
| MONTH_BEGIN (+/-n) | Will put the value of the date of the beginning of the month the report is run. |
| MONTH_END (+/-n) | Will put the value of the date of the end of the month the report is run. |
| QTR_BEGIN (+/-n) | Will put the value of the date of the beginning of the quarter the report is run. |
| QTR_END (+/-n) | Will put the value of the date of the end of the quarter the report is run. |
| YEAR_BEGIN (+/-n) | Will put the value of the date of the beginning of the year the report is run. |
| YEAR_END (+/-n) | Will put the value of the date of the end of the year the report is run. |
| MONTH_AGO (+/-n) | Will put the value of the date of one month before the report is run. |
| MONTH_FROM_NOW (+/-n) | Will put the value of the date of one month after the report is run. |
| YEAR_AGO (+/-n) | Will put the value of the date of one year before the report is run. |
| YEAR_FROM_NOW (+/-n) | Will put the value of the date of one year after the report is run. |
User specific keywords include the following variables in the form {user.keyword}, where keyword can be any of the terms listed below:
Support | About ELB Learning
© ELB Learning 2022