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
system
closed
October 19, 2020, 11:57am
#4
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.