ADD_TO_DATE - Add or Subract Days, Months, Years to Existing Date in Informatica

Syntax :
ADD_TO_DATE( input_date, datepart , amount )

Know more about datepart
Example 1 : Get tomorrow Date
ADD_TO_DATE( DATE_SHIPPED, 'D', 1 )

DATE_SHIPPEDRETURN VALUE
Jan 1 1997 12:00:30AMJan 02 1997 12:00:30AM


Example 2: Get Yesterday Date
ADD_TO_DATE( DATE_SHIPPED, 'D', -1 )

DATE_SHIPPEDRETURN VALUE
Jan 1 1997 12:00:30AMDec 31 1996 12:00:30AM
Mar 1 1996 5:32:12AMFeb 29 1996 2:32:12PM (Leap Year)


Note : Input Date has to be in the date format, if the date is in string format it has to be converted using To_Date Function

To know more about Date Formats Search For "Date Formats" in Forget Code.