End of Month for Date

General Usage
,
1

Why does this not work for rolling the date to 2023-06-30?

ceil(Date("2023-06-01"), Month) - Day(1)

The following works for every other date in that month, e.g

ceil(Date("2023-06-02"), Month) - Day(1)
2

lastdayofmonth is what I use

3 Likes
3

thank you! I did not know of this function.