Microsoft Office Forums - View Single Post - [Solved] Date Format for days 01-12 are americanized

Thread: [Solved] Date Format for days 01-12 are americanized

View Single Post

Old

09-07-2015, 09:37 PM

jcrennan

jcrennan is offline

jcrennan uses Windows 7 64bit

Windows 7 64bit jcrennan uses Office 2010 64bit

jcrennan uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Sep 2015

Posts: 5

jcrennan is on a distinguished road

Thumbs up

Quote:

Originally Posted by macropod

View Post

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

Reply With Quote