Calculate Period by Hour

Logic Name

Calculate Period by Hour

Function

Calculates period between the two inputs and returns the value by hour.

Data Types

Location Type
The first input handler Date
The second input handler Date
Logic output Numeric
lightbulbRefer to "Logic Specifications" for details.

Properties

Category Property Description
Comment Comment The comment will also be output to the specifications.It does not affect the conversion process.

Function Details

The logic calculates the period from the date/time of the first handler to that of the second handler by hour.
The value will be negative if the date/time of the first handler is the future than that of the second handler.
The fraction smaller than an hour in the difference between two date/time values is round down and the number of hours is returned in numeral.

Logic Sample

Mapping Definition

Logic Settings and Processing Result

The logic calculates the period from two date/time values.
Property Settings
Property Setting
None  
Input Data
2010-05-11T09:00:00.000+0900,2010-05-12T18:00:00.000+0900
2010-05-11T18:00:00.000+0900,2010-05-11T09:00:00.000+0900
2010-05-11T09:30:00.000+0900,2010-05-11T11:29:00.000+0900
Result Data
33
-9
1