Calculate Period by Day
Logic name
Calculate Period by Day (Document Mapper/Variable Mapper/Merge Mapper)
Function
This logic calculates a period between the two input date/time values and returns the result by day.
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 day.
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.
Any fraction smaller than a day in the difference between two date/time values is rounded down and the number of days 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-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 |
Output data
|
365 |
|
-158 |
|
1 |
For a list of logics, refer to Mapper Logic Guide.