Format a date

[R@emdonck]

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

[MartinLiss]

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

[QWERTY]

This seems to work:

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

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

[Ruchi]

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

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

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

[funkheads]

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

[PlausiblyDamp]

Please delete, replied to wrong thread

[SamOscarBrown]

What year is it in Newport, UK?

[Spooman]

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

[PlausiblyDamp]

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

[SamOscarBrown]

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.

[Spooman]

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

[dilettante]

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