Format a date in Microsoft Access 2007 in a query

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!
ssailerAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
How about just

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

You could add more if needed (Year, etc)

mx
0
 
GRayLConnect With a Mentor Commented:
Format(StartDate,"mmmm")
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
For example:

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

mx
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
ssailerAuthor Commented:
Thanks, everybody.  I'm just starting to get back into working with Access after ten years of being away from it.  :)
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You are welcome.

An welcome back to Access.

And thank you for using Experts Exchange ..

mx
0
 
GRayLCommented:
Ditto ;-)
0
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.

All Courses

From novice to tech pro — start learning today.