Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| b_i:arithmeticinfind [2023/03/09 03:54] – sean | b_i:arithmeticinfind [2023/05/10 01:27] (current) – sean | ||
|---|---|---|---|
| Line 2: | Line 2: | ||
| ==== Arithmetic In Find ==== | ==== 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=" |
| - | <newcolumn> | + | |
| - | ===Problem/ | + | <col sm=" |
| Arithmetic operations with dates are not supported in '' | Arithmetic operations with dates are not supported in '' | ||
| - | <code aim>FIND Account WHERE Account.Date=CURRENT_DATE-1 </ | + | <code aim>FIND Account WHERE Account.Date=CURRENT_DATE-1 </code></ |
| - | <newcolumn> | + | <col sm=" |
| - | ===Work Around=== | + | <col sm=" |
| Use functions with dates (such as '' | Use functions with dates (such as '' | ||
| - | <code aim>FIND Account WHERE Account.Date= DATE_ADD(CURRENT_DATE, | + | <code aim>FIND Account WHERE Account.Date= DATE_ADD(CURRENT_DATE, |
| + | </grid> | ||
| - | < | ||
| - | </ | ||
| {{simplenavi> | {{simplenavi> | ||