date format into a string

[Bernie Yaeger]

I'm trying to get '20030904' into a string where mdate is a date variable.
Using formatdatetime I can't seem to get closer than a shortdate, but that
yields '9/4/03', from which I could surely pull out strings using instr, but
is there a more direct way?

Tx for any help.

Bernie Yaeger

[Armin Zingler]

"Bernie Yaeger" <be*****@cherwellinc.com> schrieb

I'm trying to get '20030904' into a string where mdate is a date
variable. Using formatdatetime I can't seem to get closer than a
shortdate, but that yields '9/4/03', from which I could surely pull
out strings using instr, but is there a more direct way?

dim s as string
s = mdate.tostring("yyyyMMdd")
--
Armin

[Herfried K. Wagner [MVP]]

* "Bernie Yaeger" <be*****@cherwellinc.com> scripsit:

I'm trying to get '20030904' into a string where mdate is a date variable.
Using formatdatetime I can't seem to get closer than a shortdate, but that
yields '9/4/03', from which I could surely pull out strings using instr, but
is there a more direct way?

Have a look at 'Date.ToString(<format>)'.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

[Bernie Yaeger]

Tx Armin, Herfried.

Bernie
"Armin Zingler" <az*******@freenet.de> wrote in message
news:eA*************@TK2MSFTNGP12.phx.gbl...

"Bernie Yaeger" <be*****@cherwellinc.com> schrieb

I'm trying to get '20030904' into a string where mdate is a date
variable. Using formatdatetime I can't seem to get closer than a
shortdate, but that yields '9/4/03', from which I could surely pull
out strings using instr, but is there a more direct way?

dim s as string
s = mdate.tostring("yyyyMMdd")
--
Armin