LastDayOfMonth |
Syntax:
LastDayOfMonth(dateexpr)
Description:
Returns the last day (i.e. Sunday, Monday, etc.) of the month specified by dateexpr. For example, this function could return the name of last day of the current month.
Parameters:
|
Parameter |
Description |
|
The date to be used when determining the last day of the current month. |
The return integer is one of the following:
|
NumZ{day} |
Value |
Description |
|
vbSunday |
1 |
Sunday |
|
vbMonday |
2 |
Monday |
|
vbTuesday |
3 |
Tuesday |
|
vbWednesday |
4 |
Wednesday |
|
vbThursday |
5 |
Thursday |
|
vbFriday |
6 |
Friday |
|
vbSaturday |
7 |
Saturday |
Example:
Sub Main
'return the name of the last day of this month
lastDayOfTheMonth = LastDayOfTheMonth (Now())
EndSub
See Also
IsLeapYear, FirstDateOfDayInMonth, FirstDateOfDayInQuarter, FirstDateOfDayInYear, LastDateOfDayInMonth, LastDateOfDayInQuarter, LastDateOfWeek, LastDayOfQuarter