Try this code, it is similar to the last post:
VB Code:
Option Explicit Private Sub Form_Load() Dim s As Date, m As Integer, x As Date, mm As String s = CDate("2/1/2004") mm = Format(s, "MMMM, yyyy") s = DateSerial(Year(s), Month(s) + 1, 1) x = DateAdd("d", -1, s) MsgBox Day(x) & " days in " & mm End Sub




Reply With Quote