The Best Way for the end of month

Well hi guys.

How is the best way to get the end of month date ?

For example i have a value of 201804.

the next steps i do is to add 01 to the end of 201804. So the result is 20180401.

The last Step is to count +1 to 04 in the middle of the date. So the result ist 20180501.

The last step reduces the date with -1 to the day. The result is 20180430.

Anybody knows a easy way to manipulate Dates ?

THX

Paddy

You may have to think about waht happens if you have a different year in the previous or next month. There are these solutions and discussions about how to determine certain days in month and shift them:

3 Likes

The best two nodes for realisation is Time&Date shift and extract date & time fields

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.