Date-time macros for parameter values
You can use macros to define the values of date and datetime type parameters.
The table below lists the available macros:
| Macro | Description |
|---|---|
|
BOD |
The beginning of the current day |
|
BOW |
The beginning of the current week |
|
BOM |
The beginning of the current month |
|
BOQ |
The beginning of the current quarter |
|
BOY |
The beginning of the current year |
|
BOLD |
The beginning of the last day |
|
BOLW |
The beginning of the last week |
|
BOLM |
The beginning of the last month |
|
BOLQ |
The beginning of the last quarter |
|
BOLY |
The beginning of the last year |
|
EOD |
The end of the current day |
|
EOW |
The end of the current week |
|
EOM |
The end of the current month |
|
EOQ |
The end of the current quarter |
|
EOY |
The end of the current year |
|
EOLD |
The end of the last day |
|
EOLW |
The end of the last week |
|
EOLM |
The end of the last month |
|
EOLQ |
The end of the last quarter |
|
EOLY |
The end of the last year |
|
BOL7D |
The first day 7 calendar days ago |
|
EOL7D |
The end of the day previous to the current date |
|
BOL14D |
The first day 14 calendar days ago |
|
EOL14D |
The end of the day previous to the current date. |
|
BOL30D |
The first day 30 calendar days ago |
|
EOL30D |
The end of the day previous to the current date |
The macros for the beginning of a period return a datetime type with the time part as 00:00:00.
The macros for the end of a period return a datetime type with the time part as 23:59:59.
If macros is used for setting a parameter of date type, the time part is truncated.