PC Review


Reply
Thread Tools Rate Thread

Converting months as # to Text Month

 
 
=?Utf-8?B?QmFyYiBSZWluaGFyZHQ=?=
Guest
Posts: n/a
 
      6th Nov 2006
Programmatically, how would I convert the month from 1-12 to January -
December. Let's assume my variable for month is called MONTH.

Thanks
 
Reply With Quote
 
 
 
 
=?Utf-8?B?SmltIFRob21saW5zb24=?=
Guest
Posts: n/a
 
      6th Nov 2006
This should be close...

Dim intMonth As Integer

intMonth = 5
MsgBox Format(DateSerial(2000, intMonth, 1), "mmm")

--
HTH...

Jim Thomlinson


"Barb Reinhardt" wrote:

> Programmatically, how would I convert the month from 1-12 to January -
> December. Let's assume my variable for month is called MONTH.
>
> Thanks

 
Reply With Quote
 
Les Stout
Guest
Posts: n/a
 
      6th Nov 2006
Hi Barb,

you could try:-

Sub Month()

Dim Mnth As String
Mnth = Format(Date, "mmmm")
MsgBox "This month is : " & Mnth

End Sub


Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting Month Number to Month Text Abbreviation =?Utf-8?B?Qm9i?= Microsoft Excel Worksheet Functions 10 12th May 2007 04:11 AM
Converting Text months to sortable Numbers or Dates =?Utf-8?B?R3JlZw==?= Microsoft Excel Misc 6 1st May 2005 03:32 AM
Converting Numeric MONTH to text (i.e. 1=Jan, 2=Feb) =?Utf-8?B?Q2Fyb2w=?= Microsoft Access Queries 2 3rd Mar 2005 06:16 PM
Converting month number to text Heather Microsoft Excel Worksheet Functions 14 8th Jul 2004 01:04 AM
Converting Text Month to Number Scottie318 Microsoft Excel Worksheet Functions 7 13th Oct 2003 06:57 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:52 AM.