Updated: 2024-11-08
Use the istaskcomplete() and isnottaskcomplete() functions to test if a workflow task is complete.
For Data Mining queries, 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 test a range of dates. For example, test whether the workflow task was completed on or between two dates:
istaskcompleted("EngagementPackageSent", "2024, 08, 01", "2024, 08, 03")