, ,

Arithmetic In Find

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

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)