Beginning of Current Month
Firstly, turn on formula mode and we have access to the beginning_of_month function. It returns the date for the start of the month for the given date/timestamp.
Beginning of Next Month
To retrieve a date for the beginning of the next month, we simply need to add a month to the input date, and use the previously mentioned function (beginning_of_month) get the beginning of the month.
End of Current or Next Month
While the beginning_of_month function will always give you the 1st day of the month, retrieving the end of the month is a little trickier because some months have 31 days while others have less.
Instead, we can apply some simple arithmetic to obtain the last date of the month.
To retrieve the last date of the current month :
To retrieve the last date of the next month: