[Merge Mapper]Calculate Period by Day

Logic Name

Calculate Period by Day

Function

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

Data Types

Location	Type
The first input handler	Date
The second input handler	Date
Logic output	Numeric

Refer 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 day.
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 a day in the difference between two date/time values is round down and the number of days 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-01-01T00:00:00.000+0900,2011-01-01T00:00:00.000+0900

2010-10-10T00:00:00.000+0900,2010-05-05T00:00:00.000+0900

2010-08-11T04:00:00.000+0900,2010-08-13T03:59:59.000+0900

Result Data

365

-158