Calculate Period by Year

Calculate Period by Year

Logic name

Calculate Period by Year (Document Mapper/Variable Mapper/Merge Mapper)

Function

This logic calculates a period between the two input date/time values and returns the result by year.

Data types

Location

Type

First input handler

Date

Second input handler

Date

Logic output

Numeric

= Hint =

Refer to the following for details:

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 year.

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 years of the date/time values is calculated and the number of years 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,2012-05-01T00:00:00.000+0900

2012-05-01T00:00:00.000+0900,2010-05-01T00:00:00.000+0900

2010-05-01T00:00:00.000+0900,2012-04-01T00:00:00.000+0900

Output data

2

-2

2

 

= Hint =

For a list of logics, refer to Mapper Logic Guide.