Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
b_i:arithmeticinfind [2023/03/09 03:35] – removed - external edit (Unknown date) 127.0.0.1b_i:arithmeticinfind [2023/05/10 01:27] (current) – sean
Line 1: Line 1:
 +{{tag>Known_Issues, Issue:Find, Issue:Query, }}
 +==== Arithmetic In Find ====
  
 +<invisible> This is the template for INHERITED pages</invisible>
 +
 +<grid>
 +<col sm="1"><invisible> This is a spacer column</invisible></col>
 +
 +<col sm="5">===Problem/Limitation Description===
 +Arithmetic operations with dates are not supported in ''[[a_f:a:find|FIND]]'' action, for example using the following will not work:
 +
 +<code aim>FIND Account WHERE Account.Date=CURRENT_DATE-1 </code></col>
 +
 +<col sm="1"><invisible> This is a spacer column</invisible></col>
 +
 +<col sm="5">===Work Around===
 +
 +Use functions with dates (such as ''[[a_f:f:af:date_add|DATE_ADD]]'') instead of arithmetic operations, for example:
 +
 +<code aim>FIND Account WHERE Account.Date= DATE_ADD(CURRENT_DATE,-1) </code></col>
 +</grid>
 +
 +
 +{{simplenavi>docs:8000_appendices:0200_known_issues:arithmeticinfind:}}