Knowledge Drop

Can I use Table Calculations to show total number of days in a month?

Userlevel 5

Last tested: Feb 18, 2018

Yes, we can do that in Table Calculations.  Given a date dimension ${date}, this calc returns the number of days in the month of ${date}.

extract_days(add_days(-1, date(extract_years(add_months(1, ${date})), extract_months(add_months(1, ${date})), 1)))


This content is subject to limited support.                


0 replies

Be the first to reply!