Calculate Period by Month
Logic name
Calculate Period by Month (Document Mapper/Variable Mapper/Merge Mapper)
Function
This logic calculates a period between the two input date/time values and returns the result by month.
Data types
|
Location |
Type |
|---|---|
|
First input handler |
Date |
|
Second input handler |
Date |
|
Logic output |
Numeric |
Refer to the following for details:
-
Logic specifications (Document Mapper/Variable Mapper)
-
Logic specifications (Merge Mapper)
Properties
|
Category |
Property |
Description |
|---|---|---|
|
Comment |
Comment |
You can write a description of the logic. It doesn't affect the conversion process. |
Function details
The logic calculates the period from the date/time of the first input handler to that of the second input handler by month.
The value will be negative if the date/time of the first input handler is in the future relative to the date/time of the second input handler.
The difference between the two months and years of the date/time values is calculated and the number of months is returned as a numeric character.
Logic sample
Mapping definition
Logic settings and processing result
The logic calculates a 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 |
Output data
|
13 |
|
-1 |
|
2 |
For a list of logics, refer to Mapper Logic Guide.