| Both sides previous revision Previous revision | |
| ref:b_i:arithmeticinfind [2026/08/13 01:10] – external edit 127.0.0.1 | ref:b_i:arithmeticinfind [2026/08/13 07:11] (current) – external edit 127.0.0.1 |
|---|
| <invisible> This is the template for INHERITED pages</invisible> | <invisible> This is the template for INHERITED pages</invisible> |
| |
| <grid> | <row> |
| <col sm="1"><invisible> This is a spacer column</invisible></col> | <col size="1"><invisible> This is a spacer column</invisible></col> |
| |
| <col sm="5">===Problem/Limitation Description=== | <col size="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: | 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> | <code aim>FIND Account WHERE Account.Date=CURRENT_DATE-1 </code></col> |
| |
| <col sm="1"><invisible> This is a spacer column</invisible></col> | <col size="1"><invisible> This is a spacer column</invisible></col> |
| |
| <col sm="5">===Work Around=== | <col size="5">===Work Around=== |
| |
| Use functions with dates (such as ''[[ref:a_f:f:af:date_add|DATE_ADD]]'') instead of arithmetic operations, for example: | 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> | <code aim>FIND Account WHERE Account.Date= DATE_ADD(CURRENT_DATE,-1) </code></col> |
| </grid> | </row> |
| |
| |
| {{simplenavi>8000_appendices:0200_known_issues:arithmeticinfind}} | {{simplenavi>8000_appendices:0200_known_issues:arithmeticinfind}} |