Arithmetic In Find
This is the template for INHERITED pages
This is a spacer column
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
This is a spacer column
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)