Operand
|
Definition
|
Example
|
|
|
The date from the field or formula to the left of the operand matches the day the Task is run
|
To see AP Electronic Payments with a Payment Date matching the day the Task runs:
.png)
|
|
|
The date from the field or formula to the left of the operand is before the day the Task is run
|
To see Subcontracts and Purchase Orders (i.e. Commitments) with a date prior to the day the Task runs:
.png)
|
|
|
The date from the field or formula to the left of the operand is after the day the Task is run
|
To see AP Invoices with a "Due Back Date" that is after the day the Task runs:
.png)
|
|
|
The date from the field or formula to the left of the operand is between the day the Task runs and the number of days entered in the future
|
To see AP invoices with a discount date in the 15 days after the date the Task is run:
.png)
|
|
|
The date from the field or formula to the left of the operand is between the day the Task runs and the number of days entered in the past
|
To see Transactions with a date in the 7 days prior to the date the Task ran:
.png)
|
|
|
The date from the field or formula to the left of the operand is further in the future than the day the Task runs plus the number of days entered
|
To see Jobs where the Estimated Completed Date is more than 90 days after the day the Task ran:
|
|
|
The date from the field or formula to the left of the operand is further in the past than the day the Task runs minus the number of days entered
|
To see AP Invoices dated more than 30 days before the date the Task ran:
.png)
|
|
|
The date from the field or formula to the left of the operand is after the date the Task ran minus the number of days entered or in the future
|
To see PR Checks with Period End Dates in the 6 days before the Task ran, the same day the Task runs, or in the future:
|
|
.png)
|
The date from the field or formula to the left of the operand is after the date the Task ran minus the number of days entered or in the past
|
To see Vendors with Worker's Comp Insurance expiring in the 30 days after the Task runs, the same day the Task runs, or in the past:
|
|
.png)
|
The date from the field or formula to the left of the operand is between the two dates entered or Sage fields selected on the right
|
To see Jobs with Estimated Completion Dates between 6/30/2022 and 12/31/2022:
.png)
|
|
|
The date from the field or formula to the left of the operand is sometime in the calendar year after the date when the Task is run
|
To see PR Checks dated for the calendar year after the day the Task runs:
.png)
|
|
.png)
|
The date from the field or formula to the left of the operand matches the date entered or Sage field selected on the right
|
To see Vendors whose General Liability Insurance will expire on 12/31/2022:
.png)
|
|
|
The date from the field or formula to the left of the operand doesn't match the date entered or Sage field selected on the right
|
To see AP Invoices where the Invoice Date doesn't match the Accounting Date:
.png)
|
|
.png)
|
The date from the field or formula to the left of the operand is after the date entered or Sage field selected on the right
|
To see Jobs where the Last Cost Update was after the last time the Job was billed:
.png)
|
|
|
The date from the field or formula to the left of the operand is the same day as or later than the date entered or field selected on the right
|
To see PR Checks with a Period End Date the same day or after the Check Date:
.png)
|
|
.png)
|
The date from the field or formula to the left of the operand is before the date entered or field selected on the right
|
To see Subcontracts and Purchase Orders (i.e. Commitments) with dates prior to the date when a signed contract was received:
.png)
|
|
|
The date from the field or formula to the left of the operand is the same day as or before the date entered or field selected on the right
|
To see Jobs where the Actual Completion Date is the same day or prior to its Last Cost Update:
.png)
|
|
.png)
|
The date from the field or formula to the left of the operand is blank
|
To see AP Vendors where the Expiration Date for their Worker's Comp insurance has not been entered in Sage:
.png)
|
|
|
The date from the field or formula to the left of the operand is not blank
|
To see Jobs that have had overtime and when they had it:
.png)
|
|
|
The date from the field or formula to the left of the operand is between the two dates entered or Sage fields selected on the right
|
To see Credit Card payments dated between 12/1/2022 and 12/31/2022:
.png)
|
|
|
The date from the field or formula to the left of the operand is not between the two dates entered or Sage fields selected on the right
|
To see Vendors whose most recent invoices were not between 1/1/2022 and 12/31/2022:
.png)
|
|
|
The date from the field or formula to the left of the operand is after the day the Task runs but still in the same year
|
To see Cost Codes with Estimated Completion Dates later in the same year the Task was run:
.png)
|
|
|
The date from the field or formula to the left of the operand is between the day the Task runs and 30 days in the future
|
To see Employees who have an employment anniversary in the next 30 days:
.png)
|
|
|
The date from the field or formula to the left of the operand is between the day the Task runs and 7 days in the future
|
To see Subcontracts and Purchase Orders (i.e. Commitments) with a Delivery Date in the next 7 days after the Task is run:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the year the Task runs
|
To see Vendors who have been cut a check in the year the Task is run:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the month the Task runs
|
To see Jobs that last had a billing in the month the Task is run:
.png)
|
|
|
The date from the field or formula to the left of the operand is between the day the Task runs and 7 days prior
|
To see PR Checks with a Check Date in the last 7 days:
.png)
|
|
|
The date from the field or formula to the left of the operand is between the day the Task runs and 30 days prior
|
To see AP Invoices with an Accounting Date in the last 30 days:
.png)
|
|
|
The date from the field or formula to the left of the operand is before the day the Task runs but still in the same year
|
To Employees who were hired earlier in the year the Task runs:
.png)
|
|
|
The date from the field or formula to the left of the operand is from before the calendar year when the Task was run
|
To see Subcontracts and Purchase Orders (i.e. Commitments) with a Last Check Date from a year before to the year the Task is run:
.png)
|
|
|
The date from the field or formula to the left of the operand matches the date entered or Sage field selected on the right
|
To see AP Invoices where the Invoice Date is the same day as the Payment Date:
.png)
|
|
|
The date from the field or formula to the left of the operand is any day in the month the Task was run
|
To see AP Electronic Payments made in the same month the Task is run:
.png)
|
|
|
The date from the field or formula to the left of the operand is any day in the week the Task is run
|
To see Jobs with an Actual Start Date in the same week the Task is run:
.png)
|
|
|
The date from the field or formula to the left of the operand is any day in the calendar year the Task is run
|
To see PM Leases with an Actual End Date in the same year the Task is run:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the month after the month the Task is run
|
To see Vendors with Auto Insurance expiring in the month after the month the Task is run:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the year after the year the Task is run
|
To see Subcontracts and Purchase Orders (i.e. Commitments) scheduled to start in the year after when the Task is run:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the month before the month the Task is run
|
To see AP Checks cut in the month before when the Task is run:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the year before the year the Task is run
|
To see Employees terminated in the year before when the Task is run:
.png)
|
|
|
The date from the field or formula to the left of the operand is between the day the Task runs and the beginning of the year
|
To see AP Invoices entered from the beginning of the year up to when the Task is run:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the month of January in any year
|
To see Employees with a birthday in January:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the month of February in any year
|
To see Employees that were hired in the month of February:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the month of March in any year
|
To see Employees with a birthday in March:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the month of April in any year
|
To see Employees that were rehired in the month of April:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the month of May in any year
|
To see Employees with a birthday in May:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the month of June in any year
|
To see Employees with a birthday in June:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the month of July in any year
|
To see Employees that were hired in the month of July:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the month of August in any year
|
To see Employees with a birthday in August:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the month of September in any year
|
To see Jobs completed in the month of September:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the month of October in any year
|
To see Employees terminated in the month of in October:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the month of November in any year
|
To see Employees with a birthday in November:
.png)
|
|
|
The date from the field or formula to the left of the operand is in the month of December in any year
|
To see Employees with a birthday in December:
.png)
|
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=spacer}
.png){kind=spacer}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}
.png){kind=small}