Format a date

Hello,

How can I format a date ? the result must be
"dd/mm/yy"

for example:

Dim MyDate as Date

MyDate = Now()

The result is always "dd/mm/yy hh:mm:ss"

How can dump the "hh:mm:ss" ?

R@emdonck

Look up the Format function in Help. One of the "named" (built-in) formats for dates is Short Date and it's used like thisMsgBox Format(Now(), "Short Date")

------------------
Marty

This seems to work:

Code:

---

Dim MyDate As Date
MyDate = Format(Now, "hh:mm:ss")

---

------------------
Visual Basic Programmer
------------------
PolComSoft
You will hear a lot about it.

This uses the format string "m/d/yy", which displays the month, day, and a two-digit year.

Code:

---

Dim MyDate As Date
MyDate = Now()
Text1.Text = Format(MyDate, "m/d/yy")

---

[This message has been edited by Ruchi (edited 12-13-1999).]

here are many formats you can use:

d = one digit date
dd = two digit date
ddd = abbreviated day name
dddd = full day name

m - one digit month
mm = two digit month
mmm = abbreviated month name
mmmm = full month name

yy = two digit year
yyyy = four digit year

use any of those formats with wach other in this code:

Text1.Text = Format(MyDate, see above formats)

for instance...
Text1.Text = Format(MyDate, dd/mm/yy)
will return 27/01/99

or

Text1.Text = Format(MyDate, dddd mmm dd, yyyy)
will return Wednesday Jan 27, 1999

hope this all helps. happy programming!!

--michael

Please delete, replied to wrong thread

What year is it in Newport, UK?

Maybe 19 days after the OP and just before you know what

oops, didn't see the replies - I have no idea what happened as I replied to a different thread and somehow my response appeared there and on this one

Quote:

---

Originally Posted by Spooman

Maybe 19 days after the OP and just before you know what

---

Morning spoo...my point was this thread is 18 YEARS old (started and ended in 1999---a great album by Prince (or whatever name he now goes by), btw). But now I see our English friend PD's post was a mistake.

Back at ya, Sammi. I was making a loose reference to the Y2K issue .. read as time-warp.

Prince died last year. Are we still doing the Time Warp in this thread or what?