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
ref:b_i:arithmeticinfind [2026/08/13 00:42] – removed - external edit (Unknown date) 127.0.0.1ref:b_i:arithmeticinfind [2026/08/13 01:10] (current) – external edit 127.0.0.1
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 ''[[ref: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 ''[[ref: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>8000_appendices:0200_known_issues:arithmeticinfind}}