Calculate Period by Day

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

= 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 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

 

= Hint =

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