How to get JUST month name from a date?

[VB Programmer]

I have a date (such as 10/1/2004). How do I convert it to just "October"?
Thanks.

 

[Eliyahu Goldin]

Use format string "MMMM".

Eliyahu

 

[Shiva]

DateTime.ToString ("MMMM")

I have a date (such as 10/1/2004). How do I convert it to just "October"?
Thanks.

 

[mortb]

Something like:

Dim MyString As String = "10/1/2004"
Dim MyDateTime As DateTime = DateTime.Parse(MyString, new
CultureInfo("en-US"))
Dim Month As String = MyDateTime.ToString("MMMM", new CultureInfo("en-US"))

 

[VB Programmer]

Thanks EVERYONE! Great response and great newsgroup.

 

[sbjmagic]

How to get JUST month name from a date ???

Dim SalaryDate as DateTime
Dim MonthName as String

SalaryDate='03/11/2009'

MonthName = SalaryDate.ToString("MMMM")

It will Return 'November'

Thnx

By Shashi....

 

[bernardes]

VBA - Convert numbers to month names

(Sorry comments only in portuguese, but the code is very simple)

Solution here.

Tags: André Luiz Bernardes, MS, Microsoft, Office, VBA, Access, Excel, Word, Outlook, Sharepoint, convert, YTD, QTD, MAT, MTD, Month, Mês, converter

André Luiz Bernardes
(e-mail address removed)
http://inanyplace.blogspot.com/
Santos - SP - Brazil