Solved

Format a date in Microsoft Access 2007 in a query

Posted on 2011-03-18
6
398 Views
Last Modified: 2012-05-11
I have a query where I'm pulling the month from the date using a DatePart function:

Month: DatePart("m",[startDate])

How then, would I format this date to spell out the entire month?  I tried this

                             FullMonth: Format(DatePart("m",[startDate]),"mmmm")

but it's not working.  It's spelling out the complete months, but the months are all wrong.  

Thanks!
0
Comment
Question by:ssailer
  • 3
  • 2
6 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 333 total points
ID: 35166811
How about just

FullMonth: Format([startDate],"mmmm")

You could add more if needed (Year, etc)

mx
0
 
LVL 44

Assisted Solution

by:GRayL
GRayL earned 167 total points
ID: 35166812
Format(StartDate,"mmmm")
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 333 total points
ID: 35166823
For example:

FullMonth: Format([startDate],"mmmm  mm-dd-yyyy")

mx
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:ssailer
ID: 35166934
Thanks, everybody.  I'm just starting to get back into working with Access after ten years of being away from it.  :)
0
 
LVL 75
ID: 35166950
You are welcome.

An welcome back to Access.

And thank you for using Experts Exchange ..

mx
0
 
LVL 44

Expert Comment

by:GRayL
ID: 35167011
Ditto ;-)
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question