https://community.cloudera.com/t5/Support-Questions/Get-the-last-day-of-the-month/m-p/294070#M217033 <P>Hi, please, how can I get the last day of the month of given date in NiFi?</P><P>Step 1 could be taking the month out of the given date</P><P>Step 2 getting the last day or date of the month taken from step 1</P><P>&nbsp;</P><P>Thanks a lot.</P> Wed, 15 Apr 2020 19:05:07 GMT Luwi 2020-04-15T19:05:07Z https://community.cloudera.com/t5/Support-Questions/Get-the-last-day-of-the-month/m-p/294070#M217033 <P>Hi, please, how can I get the last day of the month of given date in NiFi?</P><P>Step 1 could be taking the month out of the given date</P><P>Step 2 getting the last day or date of the month taken from step 1</P><P>&nbsp;</P><P>Thanks a lot.</P> Wed, 15 Apr 2020 19:05:07 GMT https://community.cloudera.com/t5/Support-Questions/Get-the-last-day-of-the-month/m-p/294070#M217033 Luwi 2020-04-15T19:05:07Z https://community.cloudera.com/t5/Support-Questions/Get-the-last-day-of-the-month/m-p/294076#M217037 <P>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 <A href="https://community.cloudera.com/t5/Community-Articles/Python-Script-in-NiFi/ta-p/246406" target="_self">ExecuteScript processor</A> and Python's calendar library with the function <A href="https://docs.python.org/3/library/calendar.html#calendar.monthrange" target="_self">calendar.monthrange</A>(year,&nbsp; month) that returns the last day of month as the second argument.&nbsp;</P> Wed, 15 Apr 2020 19:55:33 GMT https://community.cloudera.com/t5/Support-Questions/Get-the-last-day-of-the-month/m-p/294076#M217037 aakulov 2020-04-15T19:55:33Z