This is an old revision of the document!
Arithmetic In Find
<columns 100% 4% 48%>
<newcolumn>
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
<newcolumn>
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)
<newcolumn> </columns>