Convert numerical month to it's text equivalent 3

[Trogg]

After using Datepart on a date field to isolate the month is there a function or simple way to display the number's text equivalent?(Ie. 7 is "July" or 1 is "January")

Thanks in advance!

 

[lameid]

I don't think so unless you want to write your own function that uses Select Case to conditionally return it.

Althought a better solution is to just use the format function to get what you want...


Format (<Date>, "mmmm")


Where <Date> is the date you want to display the month for.

 

[JerryKlmns]

Trogg,

lameid assumes that you still have that date in your table, that the month was isolated. If not then

Format("2007-" & yourMonthField & "-01", "mmmm")

 

[LarrySteele]

Trogg,

You can use the MonthName() function. It takes the month as Long and returns the full name of the month.

[tt]MonthName(8) returns August[/tt]

The function has an optional second argument that allows you to get the month's abbreviation:

[tt]MonthName(9) returns Sep[/tt]

HTH,
Larry

 

[Trogg]

Awesome Jerry!... Here is what i wound up with...

=Format("2007-" & [Enter the number of the month desired] & "-01","mmmm")

Works like a charm in my report!

Double Cudos to you!

 

[Trogg]

Just tried Larry's too!

=MonthName([Enter the number of the month desired])

Simpler and works too! I was not aware of the MonthName function. Thanks Larry! 2 solutions both work... stars to you both.

 

[LarrySteele]

Trogg - glad we could help. Thanks for the star.

 

[lameid]

Have a star Larry... That one snuck by me.

I thought Trogg had the original date because he said he had used month to get the value. Oh, well. If I had suspected that I would have recommended using Dateserial rather than letting Access do an implicit conversion to date as JerryKlms posted but clearly monthname is the way to go.

 

[LarrySteele]

Thanks lameid! I picked up that function many, many years ago in one of those email tips. I'm surprised I still remember it because I've rarely used it.

- Larry