Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Is there a function to determine # days in a month?
Hi Jenny, Missed a divide by 4 Case 2 If Int(DatePart("yyyy", mydate) / 4) - DatePart("yyyy", mydate)/4 = 0 Then Gerrys = 29 Else Gerrys = 28 Sorry but Mike's look...- gerryk
- Post #8
- Forum: Microsoft: Access Other topics
-
Is there a function to determine # days in a month?
Hi Jenny, Try this In Module. add new put in the code below Function DaysofMonth(mydate) If IsDate(mydate) Then If DatePart("m", mydate) = 1 Then DaysofMonth = 31 ElseIf DatePart("m", mydate) = 2 Then If Int(DatePart("yyyy", mydate) / 4) -...- gerryk
- Post #6
- Forum: Microsoft: Access Other topics
