Format Date

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Format Date

Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

December 17th, 2007, 12:11 AM

Tim Johnson Tim Johnson is offline

Tim Johnson is offline

Registered User

Join Date: Nov 2007

Posts: 5

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Format Date

How can I format a date field in a query to show the month and year.

If the date is 12/16/2007 I would like to display December 2007.

Thanks

Old

December 17th, 2007, 08:18 AM

wscheiman

wscheiman is offline

Authorized User

Join Date: Oct 2003

Posts: 75

Thanks: 0

Thanked 0 Times in 0 Posts

Default

You could use the Format() function, like this:

Format("12/16/2007", "mmmm yyyy")

Hope that helps.

Warren

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
date format differs, need to force format somehow	patricolsson	ASP.NET 2.0 Basics	1	December 3rd, 2009 12:53 AM
Convert British format date to American format?	fyr	PHP How-To	0	December 19th, 2007 03:17 PM
Help with date format	gregalb	SQL Server 2000	1	February 13th, 2007 10:15 AM
How to give Date format while entering date	Subuana	Beginning VB 6	4	March 17th, 2006 07:25 AM
date format differs, need to force format somehow	patricolsson	HTML Code Clinic	2	January 12th, 2006 05:55 AM