Finding # of days current month 2

[SHAWTY721]

I am trying to figure out how to find the number of days in the current month. I was wondering if there any functions that could do this.

 

[JerryKlmns]

You could build one:

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

 

[RuralGuy]

Jerry is correct and here's a neat URL to bookmark:

http://www.pacificdb.com.au/MVP/Code/Dates.htm

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit

 

[SHAWTY721]

Thanks, JerryKlmns and RuralGuy for the help.