Date Format for days 01-12 are americanized

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Date Format for days 01-12 are americanized

09-07-2015, 09:37 PM

jcrennan

Windows 7 64bit Date Format for days 01-12 are americanized

Office 2010 64bit

Novice

Join Date: Sep 2015

Posts: 5

Quote:

Originally Posted by macropod

Try changing:
Me.pDate.Value = Format(Date, "dd/mm/yyyy")
to:
Me.pDate.Value = Format(Date, "dd mmm yyyy")

Thanks Very much that seems to work fine and has solved my issue

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to count even exact date 90 days	redza	Excel	1	09-17-2013 03:36 AM
Date Field to add 10 Days to Current Date	Erbwon	Word	6	11-12-2012 06:17 PM
Set calendar alarm x days before end date	el_ja	Outlook	2	01-19-2012 10:09 AM
30+ days Variable Day Date Calculations via Fields	ztag	Word	2	01-06-2012 11:12 AM
Creating an Auto-Calc'd Date? Today+7 Days?	SoCalTelephone	Word	0	10-06-2010 10:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:02 PM.