Subtract −

Syntax:

N value_1 − N value_2
first_date − second_date
date − number

 

Return Value:

N or D result

 
Precedence:7
Description:

This operand can be used for subtracting numerical or date fields
If the second date is later than the first date, the result is a negative number of days

 

Example:

43 − 32 = 11
25.12.1992 − 25.12.1991 = 366
25.12.1992 − 30 = 25.11.1992