Monthrange in Alteryx

[terrellchong]

In python, there is this monthrange function which is very useful to find out the days in particular month and also particular year (leap year)

In python we will only have to do this to get monthrange

 x[i] = calendar.monthrange(Year_S, Month_S)[1]

whereas in Alteryx, we will have to do this

datetimeday(DateTimeTrim(DateTimeParse([START_DATE],'%Y-%m-%d'),'lastofmonth'))

The different are enormous and I can see that Alteryx team was able to add in this in a jiffy.

I was hoping we can simplify the code so that users wont have to go and dig around to find a way to get thru.

This will be helpful in doing calculations like insurance/interest premium, where we need to find the remaining days of in the month.