Extracting month name

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

--
Regards,
Peter

Nov 12 '05 #1

44306

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

--
Hope this helps
Arno R
"wolftor" <wo*****@rogers.com> schreef in bericht
news:cu********************@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

Nov 12 '05 #2

Tom Wickerath

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" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...

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

--
Hope this helps
Arno R

**************************************************
"wolftor" <wo*****@rogers.com> schreef in bericht
news:cu********************@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

Nov 12 '05 #3

Rick Brandt

"Arno R" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...

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

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

Nov 12 '05 #4

Arno R

Rick, You are right.

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

Arno R

"Rick Brandt" <ri*********@hotmail.com> schreef in bericht
news:bo*************@ID-98015.news.uni-berlin.de...

"Arno R" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...
Peter,
Format(Month(Date),"mmmm")

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

Nov 12 '05 #5

by: wolftor | last post by:

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

Microsoft Access / VBA

short week name and month name.

by: Guoqi Zheng | last post by:

I know now.dayofweek can return week name, but it is something like, monday, tuesday, I only need to return Mon to represent monday. And for month name, I only need to have jan, Feb, etc. short...

Visual Basic .NET

Month Name in c# (August)

by: sck10 | last post by:

Hello, What I am trying to do is get the string(August) from: hdnMonth.Value = DateTime.Now.Month.ToString(); Does c# have a function like the vb function "MonthName" ? hdnMonth.Value =...

ASP.NET

Diplaying month name from database datetime

by: bbpitpit | last post by:

hi there, i'm new here, can i know how to display the month name from database's datetime? for example: in database the date column storing 12/03/2006 and I want to display only it's month name...

ASP / Active Server Pages

Convert Month Number to Month Name in Report based on query

by: CindySue | last post by:

Hello--I've got a query that uses DatePart("m",) to select records for a particular month, and then a report based on that query. I'd like to be able to create a field in the report that says what...

Microsoft Access / VBA

month name from the sql query

by: sachin shah | last post by:

Hi all i want result as month name from my query i tried with the following query but it give result as month number like (8) select (month(getdate())) as expr i want result as month...

Microsoft SQL Server

Represent month name in XML

by: howa | last post by:

Are there any guideline for representing month name in XML? (using XML schema) Currently I just use string e.g. <report month="Sep" ... Is it okay or any suggestion?

.NET Framework

converting month number to month name

by: girl23 | last post by:

I am using a function prototype to convert month number to month name. basically you ask the compiler to enter int from 1 to 12 and then convert it. printMonth ( number ); is the prototype and...

C / C++

convert month number to month name

by: Be Borth | last post by:

I saw previous solutions to convert a month number (1) to a month name (January). I have a database with 200+ dates. In a query, I use the "Part" function DatePart("m",), to extract the month...

Microsoft Access / VBA

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Similar topics