End Of Month
End Of Month
(OP)
i need Some Code to Find if its the End of the Month
and what month we are Currently on. useing the calendar Control in VB
and what month we are Currently on. useing the calendar Control in VB
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: End Of Month
If Month(myDate+1) > Month(myDate) Then
' myDate is end of month
The name of the month can be got from :
Format(myDate,"mmmm")
Using "mmmm" above will give June
Using "mmm" above will give Jun
Using "mm" above will give 06
Using "m" above will give 6
Good Luck
johnwm
RE: End Of Month
' myDate is end of month
Were is MyDate Coming from ?
the example you provided does nothing
RE: End Of Month
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: End Of Month
Dim myDate As Date
myDate = Date
myDate = myDate + 11
If Month(myDate + 1) > Month(myDate) Then
MsgBox myDate & " is the end of the month."
MonthEnd = True
Else
MonthEnd = False
End If
End Function
This should od it for you.
Derrick