Format a date in Microsoft Access 2007 in a query

Posted on 2011-03-18
Medium Priority
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.  

Question by:ssailer
  • 3
  • 2
LVL 75

Accepted Solution

DatabaseMX (Joe Anderson - Microsoft Access MVP) earned 1332 total points
ID: 35166811
How about just

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

You could add more if needed (Year, etc)

LVL 44

Assisted Solution

GRayL earned 668 total points
ID: 35166812
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft Access MVP)
DatabaseMX (Joe Anderson - Microsoft Access MVP) earned 1332 total points
ID: 35166823
For example:

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

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.


Author Comment

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

An welcome back to Access.

And thank you for using Experts Exchange ..

LVL 44

Expert Comment

ID: 35167011
Ditto ;-)

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

624 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