Adding my +1. This feature prevents our organization from really using this as it would be integral to a lot of the tables we would need to create. The current workaround is not feasible at scale.

Much after the topic, but for those who come here looking for an answer this is simple and would work too: DAY(DATEADD(DATEADD(DATETIME_FORMAT(TODAY(),‘YYYY-MM’),1,‘month’),-1,‘days’))