Calculate Year

Logic Name

Calculate Year

Function

Increases or decreases the year of the input date/time and returns the date/time value.

Data Types

Location Type
The first input handler Date
The second input handler Numeric
Logic output Date
lightbulbRefer 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

Calculation

The logic adds the numeric value of the second input handler in years to the date/time of the first input handler.Digits after the decimal point are round off.

The first input handler (date/time) The second input handler (number of years) The output date/time
2005-01-01T00:00:00+0900 1 2006-01-01T00:00:00+0900
2005-01-01T00:00:00+0900 1.23 2006-01-01T00:00:00+0900
2005-01-01T00:00:00+0900 -1 2004-01-01T00:00:00+0900

Logic Sample

Mapping Definition

Calculate Year

Logic Settings and Processing Result

The logic increases or decreases the year of the input date/time and outputs the date/time value.
Property Settings
Property Setting
None  
Input Data
2007-01-01T01:00:00.000+0900,-2
2008-02-02T02:00:00.000+0900,8
2009-03-03T03:00:00.000+0900,20
Result Data
2005-01-01T01:00:00.000+0900
2016-02-02T02:00:00.000+0900
2029-03-03T03:00:00.000+0900