Perform Ceil function for DateTime up to last time in month


If I have a DateTime how can I ceil that value up to the last datetime possible for that month ?

ie if I had

2021-09-21T08:00:00 Utc I want a function to return 2021-09-30T23:59:59.999 Utc:


In the end I added a time to get into the next month. I then floored that value to the start of the month and then subtracted a nano second.
Nasty but works I guess.

This topic was automatically closed 90 days after the last reply. We invite you to open a new topic if you have further questions or comments.