DateValue: How to have a capitalised "weekday"?

		Microsoft Office Forums > Microsoft Word > Word VBA
DateValue: How to have a capitalised "weekday"?

FAQ

Thread Tools

Display Modes

01-19-2013, 02:31 AM

tinfanide

Windows 7 64bit DateValue: How to have a capitalised "weekday"?

Office 2010 32bit

Expert

Join Date: Aug 2011

Posts: 312

Quote:

Originally Posted by gmaxey

It works here. Returning "Thu" here.

You code can be greatly simplified:

Sub EntryDateII()
Selection.Text = Format(Now, "yyyy-mm-dd DDD hh:mm:ss")
End Sub

Sorry. I should have made it clearer.
I would like to return THU instead of Thu.
Thanks.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
'Linking' entered information to other "cells" from an original "cell" in MS Word	Wade	Word	6	09-03-2012 05:22 PM
NumberFormat: Capitalised Weekday Letters???	tinfanide	Excel Programming	3	04-17-2012 04:46 AM
How to edit the "Format" and the "show level" of an EXISTING table of content?	Jamal NUMAN	Word	2	08-14-2011 10:46 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
"Microsoft Excel Application" missing in the "Component Services" on win08	sword.fish	Excel	0	02-26-2010 02:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:41 AM.