Differences

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

--- b_i:arithmeticinfind [2023/03/09 03:35] – ↷ Page moved from b_l:arithmeticinfind to b_i:arithmeticinfind sean
+++ b_i:arithmeticinfind [2023/05/10 01:27] (current) – sean
@@ Line 1: / Line 1: @@
-{{tag>Known_Issues, Issue:Find, Issue:Queries, }}
+{{tag>Known_Issues, Issue:Find, Issue:Query, }}
 ==== Arithmetic In Find ====
-<hidden> This is the template for INHERITED pages</hidden>
+<invisible> This is the template for INHERITED pages</invisible>
-<columns 100% 4% 48%>
+<grid>
-<hidden> DO NOT PLACE TEXT HERE</hidden>
+<col sm="1"><invisible> This is a spacer column</invisible></col>
-<newcolumn>
-===Problem/Limitation Description===
+<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>
+<code aim>FIND Account WHERE Account.Date=CURRENT_DATE-1 </code></col>
-<newcolumn>
+<col sm="1"><invisible> This is a spacer column</invisible></col>
-===Work Around===
+<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>
+<code aim>FIND Account WHERE Account.Date= DATE_ADD(CURRENT_DATE,-1) </code></col>
+</grid>
-<newcolumn>
-</columns>
 {{simplenavi>docs:8000_appendices:0200_known_issues:arithmeticinfind:}}