Arithmetic In Find
<invisible> This is the template for INHERITED pages</invisible>
<invisible> This is a spacer column</invisible>
===Problem/Limitation Description===
Arithmetic operations with dates are not supported in
FIND action, for example using the following will not work:
FIND Account WHERE Account.Date=CURRENT_DATE-1
<invisible> This is a spacer column</invisible>
===Work Around===
Use functions with dates (such as DATE_ADD) instead of arithmetic operations, for example:
FIND Account WHERE Account.Date= DATE_ADD(CURRENT_DATE,-1)