Solved

Format a date in Microsoft Access 2007 in a query

Posted on 2011-03-18
6
365 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 - Access MVP) 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 - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 333 total points
ID: 35166823
For example:

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

mx
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Familiarize people with the process of utilizing SQL Server views 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 Access…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

760 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now