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!

Reply