SET_DATE_PART - Change date or month or year part in DateTime in Informatica

Syntax
SET_DATE_PART( date, format, value )

Example : Change the month to July, irrespective of input month.
SET_DATE_PART( DATE_PROMISED, 'MON', 7 )

DATE_PROMISEDRETURN VALUE
Jan 1 2012 12:15:56AMJul 1 2012 12:15:56AM