I mostly write macros in word using VBA. A user
needs to enter a date like this one: 070797 and I need it to look like this:
July 07, 1997 on the document. Can you help? Also, are there other ways of
formatting dates? I've tried putting the date in a variable and doing
something like this:
myDate = DTPicker1.value
format(myDate, "mmm, & " " & mid(3, 2 ) & ", " & right(2))
But, this didn't work.
I_Byte
0
Newbie Poster
Recommended Answers
Jump to PostFormat(Date(),"mmmm dd"", ""yyyy")
Jump to PostYou say the book has problems without answers? Is it possibly meant to be used as a student's textbook? If you really like the book, perhaps you can check the publisher's website to see if there is an "answer key" softcover available?
Jump to PostOK, I am little confused, are you doing this Date time thing in VBA or VB.NET? you started the thread with VBA?
Just want to clarify
All 11 Replies
Paladine
138
Master Poster
Team Colleague
I_Byte
0
Newbie Poster
I_Byte
0
Newbie Poster
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
I_Byte
0
Newbie Poster
Paladine
138
Master Poster
Team Colleague
Paladine
138
Master Poster
Team Colleague
I_Byte
0
Newbie Poster
Paladine
138
Master Poster
Team Colleague
Paladine
138
Master Poster
Team Colleague
I_Byte
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.