Calculate Period by Minute

Calculate Period by Minute

Logic name

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

Function

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

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

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 minute in the difference between two date/time values is rounded down and the number of minutes 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-11T01:00:00.000+0900,2010-05-11T02:30:00.000+0900

2010-05-11T10:30:00.000+0900,2010-05-11T09:00:00.000+0900

2010-05-11T09:30:00.000+0900,2010-05-11T09:31:59.000+0900

Output data

90

-90

1

 

= Hint =

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