Five Stars

Tmap get the last day of the previos month

So i have a situation, Where i have to get the last day of the previos month.

Example if  the  present date is september 25 i have to get August 31 .And it has to be in this format YYYY-MM-DD.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

Re: Tmap get the last day of the previos month

This will work

 

TalendDate.getLastDayOfMonth(TalendDate.addDate(TalendDate.getCurrentDate(),-1,"MM") ) 

 

and to get in YYYY-MM-DD format change your port dateformat to yyyy-MM-dd from default format.

 

Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

3 REPLIES
Six Stars

Re: Tmap get the last day of the previos month

This will work

 

TalendDate.getLastDayOfMonth(TalendDate.addDate(TalendDate.getCurrentDate(),-1,"MM") ) 

 

and to get in YYYY-MM-DD format change your port dateformat to yyyy-MM-dd from default format.

 

Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Five Stars

Re: Tmap get the last day of the previos month

how can I make it a string

Six Stars

Re: Tmap get the last day of the previos month

To convert to string 

 

FormatterUtils.format_Date(TalendDate.getLastDayOfMonth(TalendDate.addDate(TalendDate.getCurrentDate(),-1,"MM")) , "yyyy-MM-dd").toString()