Last day of the month

[alexd-bes]

Hi there,

I am trying to get occurrences function to work with a jsonb column that has rrule settings.
I want to get occurences for once a month, on the last day of the month.
I have tried bymonthday as -1 but get an error about invalid date (looks like it is trying to set a date as -1 in this case).

I also tried setting bymonthday as [28,29,30,31] and bysetpos as [-1], however that gives me the 28,29,30,31 of each month every month.

If I set the bymonthday as 31, it works until I get to February, and then it returns the 28th of every month.

Do you have any suggestions for how I can make occurrences return the last day of the month accurately?
Or how I can amend the sql code locally to fix any bug?

Thanks in advance,

Alex