A month can contain 28, 29, 30, or 31 days. A year can contain 365 or 366 days. Because of this inconsistency, the following operations can give unexpected results:
The following rules are used:
The operation 2000-03-31 + %MONTHS(1) - %MONTHS(1) becomes 2000-03-30.