FirstDateOfDayInMonth |
Syntax:
FirstDateOfDayInMonth(dateexpr, NumZ{day})
Description:
Returns the date of the first instance of the specified day in the month of the date specified. For example, this function could return the date of the first Monday of next month.
Parameters:
|
Parameter |
Description |
|
The date to be used when determining the first instance of the day. |
|
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 date of the first Sunday of this month.
firstSundayofthismonth= FirstDateOfDayInMonth(Now(),1)
'return the date of the first Monday of next month.
firstMondayofnextmonth = FirstDateOfDayInMonth(DateAdd(1,"m",Now()),2)
See Also:
IsLeapYear, FirstDateOfDayInQuarter, FirstDateOfDayInYear, LastDateOfDayInMonth, LastDateOfDayInQuarter, LastDateOfDayInYear, LastDateOfWeek, LastDayOfMonth, LastDayOfQuarter, LastDayOfYear