Extracting month name

Month(date) shows the month number. Is there a way to get the month name
ie. October?

--
Regards,
Peter

Peter,
Format(Month(Date),"mmmm")

--
Hope this helps
Arno R


"wolftor" <wolftor@rogers.com> schreef in bericht
news:cubpb.160822$3f.123874@twister01.bloor.is.net .cable.rogers.com...[color=blue]
> Month(date) shows the month number. Is there a way to get the month name
> ie. October?
>
> --
> Regards,
> Peter
>
>
>[/color]

You can also use the MonthName function (Access 2000 and later).

MonthName(month[, abbreviate])

month: required.
The numberic designation of the month (January is 1, February is 2, etc.).

abbreviate: Optional.
Boolean value that indicates if the month name is to be abbreviated. If omitted, the
default is False, which means that the month name is not abbreviated.

To get the month name from the current date, you can use:

MonthName(month(date))

Tom

**************************************************
"Arno R" <arracomn_o_s_p_a_m@tiscali.nl> wrote in message
news:3fa547bb$0$79342$5fc3050@dreader2.news.tiscal i.nl...

Peter,
Format(Month(Date),"mmmm")

--
Hope this helps
Arno R

**************************************************
"wolftor" <wolftor@rogers.com> schreef in bericht
news:cubpb.160822$3f.123874@twister01.bloor.is.net .cable.rogers.com...

Month(date) shows the month number. Is there a way to get the month name ie. October?


Regards,
Peter

"Arno R" <arracomn_o_s_p_a_m@tiscali.nl> wrote in message
news:3fa547bb$0$79342$5fc3050@dreader2.news.tiscal i.nl...[color=blue]
> Peter,
> Format(Month(Date),"mmmm")[/color]

Incorrect. You want just...

Format(Date, "mmmm")


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Rick, You are right.

I just was too quick, sorry Peter
However, in januari it works ... <g>

Arno R



"Rick Brandt" <rickbrandt2@hotmail.com> schreef in bericht
news:bo4a4a$17ueu3$1@ID-98015.news.uni-berlin.de...[color=blue]
> "Arno R" <arracomn_o_s_p_a_m@tiscali.nl> wrote in message
> news:3fa547bb$0$79342$5fc3050@dreader2.news.tiscal i.nl...[color=green]
> > Peter,
> > Format(Month(Date),"mmmm")[/color]
>
> Incorrect. You want just...
>
> Format(Date, "mmmm")
>
>
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>
>[/color]