Sage 100

Via Sage KB - fyi - was new info to me: How to add or subtract days to a date in Visual IntegratorProducts | Sage 100 **Description | How to add or subtract days to a date in Visual Integrator** **Resolution** | Set the Operation for the Date field to Calculated Set the Date Mask to 1-YYYYMMDD Enter the following calculation: _OBJ'addDays$(A$,X) where A$=date in YYYYMMDD format and X=number to be added or subtracted Note: if subtracting days, use negative number **Note: This example only applies to Business Framework tables**

Interesting as I had to have Perform Logic written to select invoices for the prior day (-1). Great tip, thank you!

Here's an alternative method: Create numeric data type temp001, calculated field is JUL(2016,12,13)-10 Then, if you want to subtract 10 days, in the data type string (calculated) field you want the result: DTE(Temp001) The first formula in the temp field converts the date to a julian numeric value, then subtracts 10 days. If you want to use todays date use JUL(0,0,0). The second formula converts the julian numeric value back to a date.