How can I get the last day of the month.

The function datetime of sncode can be extended.

You can use something like this. 
datetime(date:payment_date_day, extended:true, format:"%Y-%m-%SNlastdayofmonth");

Do not forget to add the extended:true parameter.