How to get the last day of the month in informatica power center? We can use the transformation function LAST_DAY which Returns the date of the last day of the month for each date in a port.

Syntax
LAST_DAY(pass_the_input_date)

Example
LAST_DAY( PLAN_END_DATE )

Let’s consider a real time scenarios. We have a PLAN effective date and Plan end date in a table. The plan end date should be populated as last day of the plan begin effective date. Let’s do this by using the function LAST_DAY.