How to count number days in selected months?

[harleen_singh]

I want if count of days in the selected month

suppose if someone select aug and sep in listbox

it should give me 31+ 30=61 days.

how to achievet this?

thanks

[jagan]

Hi,

Try like this

=Num(MonthStart(Max(DateFieldName)) - MonthEnd(Min(DateFieldName)))

Hope this helps you.

Regards,

Jagan.

[#3]

below formula will give exact count

=

num(Monthend(max(DateFieldName)) -Monthstart(min([DateFieldName]

)))

[#4]

below formula will give exact count

=

num(Monthend(max(DateFieldName)) -Monthstart(min([DateFieldName]

)))

by

sadick

[#5]

try somthing like this,

1. Load your Month number in inline table

LOAD * INLINE

[    Month, MonthNum  

     January, 01  

     February, 02  

     March, 03  

     April, 04  

     May, 05  

     June, 06  

     July, 07  

     August, 08  

     September, 09  

     October, 10  

     November, 11  

     December, 12

];

2. Get the max and min date of a month using the formula

Load

monthstart(Date(Makedate($(year3),3,31),'MM/DD/YYYY')) AS Monthstart

monthstart(Date(Makedate($(year3),3,31),'MM/DD/YYYY')) AS Monthstart

Autogenerate 12;

3. Use the function networkdays() and get the date difference

[daveelliott]

You could try something like this,

CEIL(NUM(MonthEnd(Max([DateField])) - MonthStart(MIN([DateField]))))