calculate-time-difference
Description
calculate-time-difference adaptor calculates the time difference between two datatable columns (column one - column two), using a specified unit of measurement (defaults to day).
Note that the order of columns selected is important for the output values.
Inputs
data
Type: datatable
Required: Yes
The datatable containing two date/time columns.
column one
Type: text
Required: Yes
The name of the column containing reference date/time values.
column one format
Type: text
Required: No
The format of data in column one based on Unicode Technical Standard #35. If unspecified, defaults to ISO 8601 date/time.
column two
Type: text
Required: Yes
The name of the column containing date/time values.
column two format
Type: text
Required: No
The format of data in value column based on Unicode Technical Standard #35. If unspecified, defaults to ISO 8601 date/time.
difference column
Type: text
Required: No
The name of the new column containing time difference values. If unspecified, defaults to difference.
difference unit
Type: text
Required: No
The unit of time measurement. Possible values are years, quarter, months, weeks, days, hours, minutes, seconds, or milliseconds. If unspecified, defaults to days.
Outputs
data
Type: datatable
A datatable with the new column added.
Examples
Example 1: Default behaviour.
Inputs:
data:
| Sample ID | Received date | Sequence date |
|---|---|---|
Sample A | 2020-11-01 | 2020-11-21 |
Sample B | 2020-12-11 | 2020-12-19 |
Sample C | 2020-12-11 | 2020-12-11 |
column one: Sequence date
column one: Received date
Outputs:
data:
| Sample ID | Received date | Sequence date | Processing time |
|---|---|---|---|
Sample A | 2020-11-01 | 2020-11-21 | 20 |
Sample B | 2020-12-11 | 2020-12-19 | 8 |
Sample C | 2020-12-11 | 2020-12-11 | 0 |
-> Calculated the time difference between the two datatable columns Sequence date and Received date.
Use Cases
Calculating the time between patient admission to the hospital and the sample date of the first positive sample
Calculate a person's age
Use pharmaceutical expiry dates to predict potential stock outs
Sort or filter data based on time differences
Last updated