topic display no.of days in a month dynamically in Dashboards & Analytics Discussions https://community.incorta.com/t5/dashboards-analytics-discussions/display-no-of-days-in-a-month-dynamically/m-p/5937#M732 <P>Is there a calendar function available to display number of days in every month of a specified year</P> Thu, 01 Aug 2024 09:39:10 GMT MT10 2024-08-01T09:39:10Z display no.of days in a month dynamically https://community.incorta.com/t5/dashboards-analytics-discussions/display-no-of-days-in-a-month-dynamically/m-p/5937#M732 <P>Is there a calendar function available to display number of days in every month of a specified year</P> Thu, 01 Aug 2024 09:39:10 GMT https://community.incorta.com/t5/dashboards-analytics-discussions/display-no-of-days-in-a-month-dynamically/m-p/5937#M732 MT10 2024-08-01T09:39:10Z Re: display no.of days in a month dynamically https://community.incorta.com/t5/dashboards-analytics-discussions/display-no-of-days-in-a-month-dynamically/m-p/5939#M734 <P>Not a single function, but you could use the following formula:<BR /><BR /></P> <LI-CODE lang="markup">daysBetween( monthEndDate( dim_date_inc_s.date.Date ), monthStartDate( dim_date_inc_s.date.Date ) )</LI-CODE> Thu, 01 Aug 2024 20:04:23 GMT https://community.incorta.com/t5/dashboards-analytics-discussions/display-no-of-days-in-a-month-dynamically/m-p/5939#M734 JoeM 2024-08-01T20:04:23Z