Signature (Visual Basic / VBA)
Public Function StartOfMonth( _
ByVal vDate As Variant _
) As Variant
Code Example
StartOfMonth(#01/15/96#) = #01/01/96#
StartOfMonth(#12/31/96#) = #12/01/96#
StartOfMonth(#12/01/96#) = #12/01/96#
StartOfMonth(#02/29/96#) = #02/01/96#
Parameters
| Parameter | Description |
|---|---|
| vDate | The date whose month and year components are examined to determine the date of the first day of the month. Function returns Null if vDate is Null or cannot be fixed up to a Date. |
Notes & Version History
| Note | This function DOES support pre-1900 Date/time values. |