You can include the following operators in date expressions:

Operator Meaning
+ Add a number of days to a date to produce a new date.
– The number of days between two dates, or subtract a number of days from a date to produce a new date.

The following table shows examples of date expressions. In these examples, hire_date is {01/30/1990}.

Example Resulting Value
hire_date + 5 {02/04/1990}
hire_date – {01/01/1990} 29
hire_date – 10 {01/20/1990}