# How to calculate the number of minutes in a month?

Member

Does anyone know how to calculate the number of minutes in a month?

I need to calculate the number of minutes per month to deduct from them idle time also in minutes and get the percentage of accessibility of the environment.

Regards,
Rodion

Tagged:

• Member

Hi Apollo,

I just solved this by:
(DAYOFMONTH(LAST_DAY(`sys_created_on`))*1440)

Thanks!

• Domo Employee

Also you can just do:

DAY(LAST_DAY(CURRENT_DATE()))

This will give you the days of the current month. Then you can multiply it by 1440 to get minutes a day.

Thank you,

I work for Domo

• Domo Employee

Hi,

I found this Dojo article where they found a way to do this in beast mode. https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Is-there-a-way-to-calculate-the-total-days-in-the-month-we-are/m-p/14645#M1136

This calculates the number of days in a month that we are currently in. With that you can multiply it by 1440 which is how many minutes are in a day.

Thank you,

I work for Domo
• Member

Hi Apollo,

I just solved this by:
(DAYOFMONTH(LAST_DAY(`sys_created_on`))*1440)

Thanks!

• Domo Employee