Figuring out Days in a month

[Guest]

One would never know I got an A in my Access classes!

I need to figure out the number of days in a month, based on a given date.
So if the date in the table is 2/27/04, I need to know that there are 29 days
in that particular month.

Thanks in advance!

 

[Guest]

Try this

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

 

[Douglas J Steele]

Day(DateSerial(Year([MyDateField], Month([MyDateField]) + 1, 0)) will return
the number of days for whatever month's in MyDateField

 

[Guest]

BRILLIANT! Works perfectly in the query! THANK YOU!
--
Never give up, the answer IS out there, it just takes a while to find it
sometimes!

Try this

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

--
\\// Live Long and Prosper \\//
BS"D

One would never know I got an A in my Access classes!

I need to figure out the number of days in a month, based on a given date.
So if the date in the table is 2/27/04, I need to know that there are 29 days
in that particular month.

Thanks in advance!