Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

Format a date

How would i format a date
mm/dd/yy --> dd/mon/yy in VB
0
JeremieH
Asked:
JeremieH
1 Solution
 
PaulHewsCommented:
msgbox Format(Date, "dd/mmm/yy")
0
 
bobbit31Commented:
MsgBox Format(CDate("03/31/03"), "dd/MM/yyyy")
0
 
bobbit31Commented:
doh, beaten to it ;)
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
PaulHewsCommented:
That yields 25/Mar/03
if you want 25/03/03, then Format(Date, "dd/mm/yy")
0
 
JeremieHAuthor Commented:
I think i didn't express myself properly ...
when i load my date from an oracle database to
a textbox, it comes in this format (mm/dd/yyyy ex. 4/4/2002).

when i load this date, i want it to appear in this
format(dd-mon-yyyy ex. 4-APR-2002)
0
 
PaulHewsCommented:
Format(Date, "d-mmm-yyyy")
0
 
PaulHewsCommented:
if you need the uppercase, use:

UCase(Format(date, "d-mmm-yyyy"))
0
 
joaquimbieCommented:


format(date,"d/mmm/yyyy")
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now