The DATECALC function modifies the input date and time string according to the defined specifications.
Input | Data Type | Description |
---|---|---|
Input1 | DateTime | The original date and time. |
Input2 | Integer | Sets the Calc property. (optional) |
Output | Data Type | Description |
---|---|---|
Output1 | DateTime | The new date and time.
The specified Position of the original date and time string is incremented by the amount specified by the Calc property. |
Name | Property Type | Description | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Position | choice | The position in the original date or time string to be incremented.
|
||||||||||||||||||
Calc | Integer | The value added to the specified Position in the original date and time string. A negative value (-) can be specified. |
Property | Output | |||
Input 1 | 2002-12-31T00:00:00.000 | Position | Day | 2003-01-01T00:00:00.000 |
Calc | 1 |