Count Number of Days

Count number of days between two dates

There are many cases where analysis of time periods (e.g. time required for tasks to finish) is of high value. For instance, an analysis of

  • the number of days between when an issue was submitted to a system and when the issue was marked resolved
  • the number of days between when someone is contacted and when their reply is received

Count Number of Days workflow provides you with access to date processing tools where you can easily calculate the number of days between two date fields in your dataset.

NOTE: Your dataset must include at least two date fields. You can check the existing date fields when monitoring a dataset under schema as shown in the image below. Read about how date values must be formatted on how to better prepare my data

Relevance AI - Monitoring dataset for existing date fieldsRelevance AI - Monitoring dataset for existing date fields

Relevance AI - Monitoring dataset for existing date fields

Counting number of days

Once you have uploaded your data,

  1. Select your dataset and click on Count number of days under workflows
Relevance AI - Access to Count number of days workflowRelevance AI - Access to Count number of days workflow

Relevance AI - Access to Count number of days workflow

  1. Follow the setup steps as explained below:
  • Select the field specifying the beginning of a time period
  • Select the field specifying the end of a time period
  • Enter a name for the new field which will be added to your dataset to store the results
  • Once done with the setup execute the workflow
Relevance AI - Count number of days workflow setupRelevance AI - Count number of days workflow setup

Relevance AI - Count number of days workflow setup

After the workflow is finalized, you can see the new field is added to your original dataset showing the number of days between the two date fields for each entry.

Note: If there is no date value for a document or the specified beginning date value is after the end date, nothing will be added under the new result field.