Calculate Period by Month

Logic Name

Calculate Period by Month

Function

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

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 month.
The value will be negative if the date/time of the first handler is the future than that of the second handler.
values is round down and the number of months 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-01T00:00:00.000+0900,2011-06-01T00:00:00.000+0900
2010-05-01T00:00:00.000+0900,2010-04-01T00:00:00.000+0900
2010-05-11T00:00:00.000+0900,2010-07-10T00:00:00.000+0900
Result Data
13
-1
2