DATECALC

The DATECALC function modifies the input date and time string according to the defined specifications.

Input

Number of Connections: Min: 1/Max:2
InputData TypeDescription
Input1DateTimeThe original date and time.
Input2IntegerSets the Calc property. (optional)

Output

OutputData TypeDescription
Output1DateTimeThe new date and time. The specified Position of the original date and time string is incremented by the amount specified by the Calc property.

Property

NameProperty TypeDescription
PositionchoiceThe position in the original date or time string to be incremented.


Year - increments the year
Month - increments the month
Day - increments the day
Hour - increments the hour
Minute - increments the minutes
Second - increments the seconds
CalcIntegerThe value added to the specified Position in the original date and time string. A negative value (-) can be specified.

Topic

Example

PropertyOutput
Input 12002-12-31T00:00:00.000PositionDay2003-01-01T00:00:00.000
Calc1