How to calculate nr of days of 2 given months.

[Linda]

Is there an easy way to calculate the nr of days of 2
given months. For example months; JAN - FEB.

How do you find out the total nr of days for these 2
months? Is there a function in Microsoft Access that does
that.

Many thanks for any tips or suggestions.

 

[Douglas J. Steele]

To find the number of days in a given month, use Day(DateSerial(year, month
+ 1, 0))

In other words, for the number of days in January, use
Day(DateSerial(2004,2,0)) and for the number of days in February, use
Day(DateSerial(2004,3,0)). And yes, Day(DateSerial(2004, 13, 0)) will work.

 

[Jack]

DateDiff("d",#1/1/2004#,#2/28/2004#)

 

[Guest]

Thanks I didn't know it was that simple.

Linda.

-----Original Message-----
DateDiff("d",#1/1/2004#,#2/28/2004#)


.