Hello, everyone, I need your help.
In order to calculate indicators, I need to count the number of days of the current month. I determine my current month of work via a screen input.
I would also like to know how to determine the first and last day of that month.
I thought of an input screen to manually fill in every beginning and end of month but I would like an automatic calculation.
I have loaded release dates in a date format cube, I am trying to calculate the difference between the last day of the current month and the release date (which occurs during the same month).
The calculation I am trying to put in place is the following.
Number of days of month – number of days between date of release and end of month
I was thinking of an MXC cube, but we can’t count the entity months.
Is it possible to count the number of days?