Get the last day of the month

[#1]

Hi, please, how can I get the last day of the month of given date in NiFi?

Step 1 could be taking the month out of the given date

Step 2 getting the last day or date of the month taken from step 1

Thanks a lot.

[#2 · Accepted solution]

You will need to get both the year and the month of the original date (because of the leap year considerations). In terms of how to accomplish this in NiFi one way is to use ExecuteScript processor and Python's calendar library with the function calendar.monthrange(year,  month) that returns the last day of month as the second argument.