Get the number of a specified month

[biddingbong]

Is there a function in VB to get the number of a specified month?

 

[zemp]

Try the built in Month function,

MyMonth = Month(Date)

zemp

 

[tb]

What do yo mean???

Do you want to say give me the number of "September" ?
OR
Do you want to say give me the number of "2004/09/27" ?
Then this would work ...
Function Month(Date)
Member of VBA.DateTime
Returns a whole number representing the month of the year



I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[biddingbong]

I mean if I input "May", Im gonna get 5, December Im gonna get 12 and so on..

Public Function GetMonthNumber(strMonth as String) as Integer
Select Case UCase(strMonth)
Case "JANUARY": GetMonthNumber=1
.
.
.
End Select
End Function

The function looks so silly..
Thats why Im looking for a built-in Function if there's any.

 

[zemp]

The month function.

zemp

 

[RogADog]

How about this?

GetMonthNumber = Month(DateValue("1 " & strMonth & " 2004"))

Rog