Updated: 2024-10-30
Use the istaskcomplete() and isnottaskcomplete() functions to test if a workflow task is complete.
You must use the unique ID of the relevant task with this function. The simplest way to find the unique ID is to right-click on the relevant task on the Track tab and select Copy ID for data mining. Then, paste the ID into the Query Editor window.
Use istaskcompleted() to test if a workflow task was completed on a specific date:
istaskcompleted("EngagementPackageSent", "2024, 08, 02")
You can add a second date to convert the function to a range test. For example, test whether the workflow task was completed on or between the two dates:
istaskcompleted("EngagementPackageSent", "2024, 08, 01", "2024, 08, 03")