How to calculate the number of minutes in a month?

user08823

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

user08823

Hi Apollo,

 

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

 

Thanks!

Apollo

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, 

Apollo

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, 

user08823

Hi Apollo,

 

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

 

Thanks!

Apollo

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,