Add months in Informatica in Informatica

Add months in informatica
ADD_TO_DATE( DATE_SHIPPED, 'MM', 1 )

DATE_SHIPPEDRETURN VALUE
Jan 1 1997 12:00:30AMFeb 01 1997 12:00:30AM


Subtract Months in informatica
ADD_TO_DATE( DATE_SHIPPED, 'MM', -1 )

DATE_SHIPPEDRETURN VALUE
Jan 1 1997 12:00:30AMDec 01 1996 12:00:30AM