Function Month

Devolve o mes dun ano a partir dunha data en serie xerada pola función DateSerial ou DateValue.

Sintaxe:


Month (Número)

Valor de retorno:

Enteiro

Parámetros:

Number: Numeric expression that contains the serial date number that is used to determine the month of the year.

This function is the opposite of the DateSerial function. It returns the month in the year that corresponds to the serial date that is generated by DateSerial or DateValue. For example, the expression


Print Month(DateSerial(1994, 12, 20))

devolve o valor 12.

Códigos de erro

5 Chamada de procedemento incorrecta

Exemplo:


Sub ExampleMonth
    MsgBox "" & Month(Now) ,64,"O mes actual"
End Sub