We help IT Professionals succeed at work.

Date string conversion Word vba

etech0
etech0 asked
on
Medium Priority
357 Views
Last Modified: 2012-05-12
I have a string that contains a date in the format 11/04/2011. (It gets it from Str(Date))How can I convert it to the format November 4, 2011?
Comment
Watch Question

GrahamSkanRetired
CERTIFIED EXPERT
Top Expert 2012

Commented:
Try:
Format(Cdate(MyString), "MMMM d, yyyy")
Retired
CERTIFIED EXPERT
Top Expert 2012
Commented:
Notre that if you need today' s date, you can do it directly from the Date function:

Format(Date, "MMMM d, yyyy")

Author

Commented:
Thanks!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.