last day of the month

KNIME Analytics Platform
1

Hello,

 

I would like to get the last day of the month from the year and month.

For example, we are in September 2016

And I would like to know the last day (or number of days), which is 30.

 

Thanks in advance,

 

Romain

 

2

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

3 Likes
3

It worked thanks.

I also used the date/time shift to shift to one month forward so I get the last day of the current month.

 

Thank you again,

 

Romain

1 Like