Summary
This operator calculates time interval between two columns with Date/Time values.
Configuration
Input settings of existing table
Name | Value | Opt. | Description | Example |
---|---|---|---|---|
Date + time (from) | System.DateTime | - | Column containing the start (date + time) of the time period/time. | - |
Date + time (to) | System.DateTime | - | Column containing the end (date+time) of the time period. | - |
Settings
Name | Value | Opt. | Description | Example |
---|---|---|---|---|
Unit | System.String
| - | What unit does the entered value have; minutes or hours? | - |
Name of the result column | System.String | - | Input of the name of the result column. Mandatory field! | - |
Want to learn more?
This operator calculates time interval between two columns with Date/Time values.
Examples
Example: Vacation
Situation | In this example we will check for how long the in the table employees are on vacation (in days). |
---|---|
Settings | Configure the settings and click on "Save operation". |
Result | Now the is an extra column "Length" which shows for how long they will be out of office. |
Project File | - |
Troubleshooting
Nothing known up to now.