format date variable

[Layi Mon]

Hi there,

The system date format is "yyyy/mm/dd".
Assume that today is sept 15, 2003.
Please look at my the following procedure.

Sub lin ()
dim strLin as string
strLin = date
End sub

The strLin format will be "2003/09/15".
If I want to format strLin into "yy/mm/dd", what is the
syntax? But I don't want change the system date format.

Excel 97 allow the following syntax but 2002.
strLin = format (strLin, "yy/mm/dd")

Your help appreciated,
Lin

 

[Cheryl Fischer]

In Access, you can use the Format() function, as well:

strLin = Format(Date(),"yy/mm/dd")

hth,

 

[ck]

sub formatdate()
strLin = date
msg = format(strLin,"yy/mm/dd")
msgbox msg
end sub

~ck