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

  • Seconds
  • Minutes
  • Hours
  • Days
  • Weeks
  • Calendar months
  • Quarters
  • Years

-

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.


Related topics