Skip to main content
Luwi
Gold ⭐️
April 15, 2020
Solved

Get the last day of the month

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.

aakulov
aakulovAnswer
Platinum ⭐️
April 15, 2020

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. 

1 reply

aakulov
Platinum ⭐️
aakulovAnswer
Platinum ⭐️
April 15, 2020

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. 

Translate