display no.of days in a month dynamically

[MT10]

Is there a calendar function available to display number of days in every month of a specified year

[JoeM · Accepted solution]

Not a single function, but you could use the following formula:

daysBetween(
	monthEndDate(
		dim_date_inc_s.date.Date
	), 
	monthStartDate(
		dim_date_inc_s.date.Date
	)
)