Thread: [Solved] DateValue: How to have a capitalised "weekday"?
View Single Post
 
Old 01-19-2013, 05:33 PM
fumei fumei is offline Windows 7 64bit Office XP
Expert
  
Join Date: Jan 2013
Posts: 440
fumei is on a distinguished road
Default
Selection.Text = UCase(Format(Now, "yyyy-mm-dd DDD hh:mm:ss"))

As the day of the week is the ONLY alpha text, it becomes uppercase.
Reply With Quote