This data converter modifies a date by adding or subtracting from a selected part of the date.
If the addition/subtraction causes the selected part of the date to overflow or underflow, the other parts of the date will be updated accordingly.
The input text must be a date in the standard date format, e.g. "2001-02-25 14:32:49.0".
The Get Time Between Dates data converter is configured using the following properties:
If the input to the converter is "2008-02-28 10:45:00.0" and two days should be added, the result will be "2008-03-01 10:45:00.0". Notice how the month was updated and the leap day in 2008 was taken into consideration.