number of days in month

[Bill Neilsen]

I have a monthly activities report, and as part of the report I need to use
the number of days in the month as part of a calculation.
Can anyone tell me how to have a text box show the number of days in the
current month?
Thanks in advance

 

[Duane Hookom]

Day(DateSerial(Year(Date()), Month(Date())+1,0))

 

[Bill Neilsen]

Thanks Duane, it works a treat

Day(DateSerial(Year(Date()), Month(Date())+1,0))

 

[Bill Neilsen]

The original suggestion works well, but after thinking about it a bit more I
need something a little different.
The query behind the report has a Date Field [DateCompleted] and another
field [MonthNumber: Month([DateCompleted])] This second field simply gives me
the month number of the year.
When I use this second field [MonthNumber: Month([GSECompleted])] in my
report I need a text box to tell me how many days in the month indicated. Or
even just to tell me how many days in the month of [DateCompleted] field.
Is this possible?

 

[Rick Brandt]

The original suggestion works well, but after thinking about it a bit
more I need something a little different.
The query behind the report has a Date Field [DateCompleted] and
another field [MonthNumber: Month([DateCompleted])] This second field
simply gives me the month number of the year.
When I use this second field [MonthNumber: Month([GSECompleted])] in
my report I need a text box to tell me how many days in the month
indicated. Or even just to tell me how many days in the month of
[DateCompleted] field.
Is this possible?

I have a monthly activities report, and as part of the report I need
to use the number of days in the month as part of a calculation.
Can anyone tell me how to have a text box show the number of days in
the current month?
Thanks in advance

Day(DateSerial(Year([DateCompleted]), Month([DateCompleted])+1,0)

 

[Bill Neilsen]

Thanks Rick, I see the difference in the statements. I should have guessed it
myself.
It work well.

The original suggestion works well, but after thinking about it a bit
more I need something a little different.
The query behind the report has a Date Field [DateCompleted] and
another field [MonthNumber: Month([DateCompleted])] This second field
simply gives me the month number of the year.
When I use this second field [MonthNumber: Month([GSECompleted])] in
my report I need a text box to tell me how many days in the month
indicated. Or even just to tell me how many days in the month of
[DateCompleted] field.
Is this possible?

I have a monthly activities report, and as part of the report I need
to use the number of days in the month as part of a calculation.
Can anyone tell me how to have a text box show the number of days in
the current month?
Thanks in advance

Day(DateSerial(Year([DateCompleted]), Month([DateCompleted])+1,0)