Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formatting Date in (mm/dd/yyyy) 1

Status
Not open for further replies.
AgentM

AgentM

MIS
Jun 6, 2001
387
US
I need to format the date field in mm/dd/yyyy.
Irrespective of what the user enters.
Can any body help?

Thanks
 
Sort by date Sort by votes
Try this

UserDate=your user date
myDate=Month(UserDate)+"/"+Day(UserDate)+"/"+Year(UserDate)

hope this helps... ________
George, M
 
Upvote 0 Downvote
Thank you people.
George's soln. works for me.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bdwilcox
  • Locked
  • Question
Trying to adapt VBScript to search if machine is in an AD group 6
Replies
8
Views
994
SoftwareRT
SoftwareRT
lunter
  • Locked
  • Question
How to create vbArray+vbByte (8209) in *.vbs stript
Replies
0
Views
225
lunter
lunter
Michastro
  • Locked
  • Question
Send an order to an IP power in VBS
Replies
0
Views
197
Michastro
Michastro
Don Child
  • Locked
  • Question
Oracle connection works while debugging in VBSEdit, but not when run from the command line. 1
Replies
2
Views
238
Don Child
Don Child
wchull
  • Locked
  • Question
How do I resolve this permissions error in my script?
Replies
0
Views
231
wchull
wchull

Part and Inventory Search

Sponsor

Back
Top