Function Dates Times Class

FirstDayOfMonth

Returns the first day in the month given a date value.

Signature (Visual Basic / VBA)

Public Function FirstDayOfMonth( _
    ByVal vDate As Variant _
    ) As Variant

Code Example

    FirstDayOfMonth(#01/15/96#) = #01/01/96#
    FirstDayOfMonth(#12/31/96#) = #12/01/96#
    FirstDayOfMonth(#12/01/96#) = #12/01/96#
    FirstDayOfMonth(#02/29/96#) = #02/01/96#

Parameters

Parameter Description
vDate The date whose month and year components are examined to determine the first day of the month. Function returns Null if vDate is Null or cannot be fixed up to a Date.

Notes & Version History

v2.0 Change This function has been renamed from StartOfMonth to FirstDayOfMonth.