Adding or Subtracting units from a Date, Time or Timestamp
Adding or Subtracting units from a Date, Time or Timestamp
When defining your own variable to contain a date, time or timestamp (as described in step 4 above), you can optionally add or subtract units from that variable. For instance, you could create a date variable that is one year older than today's date. Or you could create a time variable that is 2 hours newer than the current time.
To add or subtract units from a date, time or timestamp variable, click the
Date Manipulation
tab while defining the Format in a Timestamp task. If you want to add a units, enter the value as +X, where X is the number of units to add. If you want to subtract units, enter the value as -X, where X is the number of units to subtract. Listed below is an example of subtracting 1 year from the current date.