View Single Post
 
Old 01-17-2013, 02:54 AM
tinfanide tinfanide is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default DateValue: How to have a capitalised "weekday"?

Code:
Sub EntryDate()

Dim sDate As String, sTime As String

// "DDD" only returns a small-letter weekday
sDate = Format(DateValue(Now()), "yyyy-mm-dd DDD")

sTime = Format(TimeSerial(Hour(Now()), Minute(Now()), Second(Now())), "hh:mm:ss")

Selection.Text = "(" & sDate & ", " & sTime & ")"

End Sub
Reply With Quote