Previous Topic: Number ExpressionsNext Topic: Time Expressions


Date Expressions

Expressions that evaluate to a date must begin with one of the components described in the following list.

After they begin with one of the specified components, they can include a numeric modifier that adds a number of years, days, or months to the initial date component or subtracts years, days, or months from it. For example, the following expression returns the date exactly one week before the current date:

current_date - 7 days

The following expression returns the date three months after an order was placed:

Order date_placed + 3 months