-
- '***********************************************************************************************************
- ' Name : xMonthDays
- ' Purpose : Retrive the number of days in a month for a determined date.
- ' Syntax : xMonthDays(TheDate)
- ' Parameters : TheDate : A date
- ' Return : The number of days. eg: 28, 31, etc...
- '***********************************************************************************************************
- Public Function xMonthDays(ByVal TheDate As Date) As Byte
- xMonthDays = Day(DateAdd("m", 1, TheDate) - Day(DateAdd("m", 1, TheDate)))
- End Function
'***********************************************************************************************************
' Name : xMonthDays
' Purpose : Retrive the number of days in a month for a determined date.
' Syntax : xMonthDays(TheDate)
' Parameters : TheDate : A date
' Return : The number of days. eg: 28, 31, etc...
'***********************************************************************************************************
Public Function xMonthDays(ByVal TheDate As Date) As Byte
xMonthDays = Day(DateAdd("m", 1, TheDate) - Day(DateAdd("m", 1, TheDate)))
End Function