date for end of month

[adjrock]

Hi community, was wondering if there was an easy way to determine end of month date based on a date value, such that date = 14/02/1981 and funtion returns 29/02/2020

[mlauber71]

It has been discussed here

last day of the month

Hi Romain, so you would need to get the last day of the previous month. Therefore first need the Time Generator (1 Row, use execution time) Than use the Extract date field node to get number of days (today would be 12) Multiply this number with -1 (Math node) Use the date time shift node and substract the number of days Use the Extract date field node again, and you are done Let me know if this works. Best, Iris

I would have to see if I have a working example lying around.

[mlauber71]

@mlauber71

I would have to see if I have a working example lying around.

It was this workflow by @ipazin from this discussion.

Previous Month Dates – ipazin

It should be possible to adapt that to your needs

[ipazin]

Hi there!

agree with @mlauber71. Should be easy to adapt

Br,
Ivan