need to change date format

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
need to change date format

Access VBA Discuss using VBA for Access programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA 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

April 9th, 2005, 06:15 AM

desprate

desprate is offline

Authorized User

Join Date: Apr 2005

Posts: 12

Thanks: 0

Thanked 0 Times in 0 Posts

Default

need to change date format

i need to change date format in my query from mm/dd/yyyy to yyyymmdd, any ideas?

Old

April 10th, 2005, 12:45 PM

rjweers

rjweers is offline

Friend of Wrox

Join Date: Nov 2004

Posts: 248

Thanks: 0

Thanked 1 Time in 1 Post

Default

rfDate: Format([Datefld],"yyyymmdd")

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CHANGE DATE FORMAT	Vision G	Access VBA	2	April 8th, 2008 12:16 PM
Change default date parameter format	JeffHickman	Reporting Services	0	February 14th, 2006 06:52 AM
how to change date format	prasannagps	Forum and Wrox.com Feedback	2	September 14th, 2005 01:28 PM
Change date format	Patrick19	Classic ASP Basics	1	March 14th, 2005 06:23 PM
date format change	yuvalk	SQL Server DTS	2	March 29th, 2004 05:14 AM