Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
a) I need to do an average from some data. But for this, I need to know how many days are in a certain month.
How can I get this number?
i.e. February 2014 --> 28 (days)
b) I need to get the number of Mondays,Tuesday, and so on in a certain month. ¿How can I get this?
i.e. January 2014 --> 5 Mondays
January 2014 --> 4 Tuesday
January 2014 --> 4 Wednesday
to get the count of mondays for example you can simply use count({<[Day Name Field] = {'Monday'}>} [Day Name Field]) you can do the same for the rest of the days.
I'm using a Master Calendar for my dates.
It has the following fields:
a) %Date Field 25-01-2014, 26-01-2014
b) Day Name field Monday,Friday,Tuesday
c) Month January, February...
(and much more)
Hi,
1) Max(day(datefield)) - Min(day(datefield))
to get the count of mondays for example you can simply use count({<[Day Name Field] = {'Monday'}>} [Day Name Field]) you can do the same for the rest of the days.