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.