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) 
  • Last modified: 2023/05/10 01:27