Arithmetic In Find AwareIM Documentation

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

{{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:}}