Count No. of Days in a month - problem?

[josephinetedesc]

Correct Answer   Re: Count number of Days of a Month

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.

Hi I looked at the answer above, but I am having trouble applying this:

I then make the table thus: I don't know what is happening!

=Monthname(AdmDate)	count(if(WeekDay(AdmDate) = 'Sat', 1))	count({<[DayAdmDate] = {'Mon'}>} [AdmDate])
Jul 2017	39	90
Aug 2017	19	55

is the problem the week day and then the month????

Jo

MonthAdm	=date(AdmDate, 'www dd/MM/yyyy')	num(WeekDay(AdmDate) +1 )	(WeekDay(AdmDate) )
Jul 2017	Sat 01/07/2017	6	Sat
	Sun 02/07/2017	7	Sun
	Mon 03/07/2017	1	Mon
	Tue 04/07/2017	2	Tue
	Wed 05/07/2017	3	Wed
	Thu 06/07/2017	4	Thu
	Fri 07/07/2017	5	Fri
	Sat 08/07/2017	6	Sat
	Sun 09/07/2017	7	Sun
	Mon 10/07/2017	1	Mon
	Tue 11/07/2017	2	Tue
	Wed 12/07/2017	3	Wed
	Thu 13/07/2017	4	Thu
	Fri 14/07/2017	5	Fri
	Sat 15/07/2017	6	Sat
	Sun 16/07/2017	7	Sun
	Mon 17/07/2017	1	Mon
	Tue 18/07/2017	2	Tue
	Wed 19/07/2017	3	Wed
	Thu 20/07/2017	4	Thu
	Fri 21/07/2017	5	Fri
	Sat 22/07/2017	6	Sat
	Sun 23/07/2017	7	Sun
	Mon 24/07/2017	1	Mon
	Tue 25/07/2017	2	Tue
	Wed 26/07/2017	3	Wed
	Thu 27/07/2017	4	Thu
	Fri 28/07/2017	5	Fri
	Sat 29/07/2017	6	Sat
	Sun 30/07/2017	7	Sun
	Mon 31/07/2017	1	Mon
Aug 2017	Tue 01/08/2017	2	Tue
	Wed 02/08/2017	3	Wed
	Thu 03/08/2017	4	Thu
	Fri 04/08/2017	5	Fri
	Sat 05/08/2017	6	Sat
	Sun 06/08/2017	7	Sun
	Mon 07/08/2017	1	Mon
	Tue 08/08/2017	2	Tue
	Wed 09/08/2017	3	Wed
	Thu 10/08/2017	4	Thu
	Fri 11/08/2017	5	Fri
	Sat 12/08/2017	6	Sat
	Sun 13/08/2017	7	Sun
	Mon 14/08/2017	1	Mon
	Tue 15/08/2017	2	Tue
	Wed 16/08/2017	3	Wed
	Thu 17/08/2017	4	Thu
	Fri 18/08/2017	5	Fri
	Sat 19/08/2017	6	Sat
	Sun 20/08/2017	7	Sun
	Mon 21/08/2017	1	Mon
	Tue 22/08/2017	2	Tue
	Wed 23/08/2017	3	Wed
	Thu 24/08/2017	4	Thu
	Fri 25/08/2017	5	Fri
	Sat 26/08/2017	6	Sat
	Sun 27/08/2017	7	Sun
	Mon 28/08/2017	1	Mon
	Tue 29/08/2017	2	Tue
	Wed 30/08/2017	3	Wed

[josephinetedesc]

aha - so now I have refined the problem:

I need to do a distinct AdmDate ....

AdmDate	AdmDay
25/08/2017 12:00:00 AM	Fri
25/08/2017 12:00:00 AM	Fri
25/08/2017 12:00:00 AM	Fri
18/08/2017 12:00:00 AM	Fri
18/08/2017 12:00:00 AM	Fri
18/08/2017 12:00:00 AM	Fri
11/08/2017 12:00:00 AM	Fri
11/08/2017 12:00:00 AM	Fri
11/08/2017 12:00:00 AM	Fri
11/08/2017 12:00:00 AM	Fri
4/08/2017 12:00:00 AM	Fri
4/08/2017 12:00:00 AM	Fri
4/08/2017 12:00:00 AM	Fri
4/08/2017 12:00:00 AM	Fri

success:

count({<[DayAdmDate] = {'Mon'}>}  distinct([AdmDate]))

Jo