One way:

MsgBox Format(Date, "mmddyy")

In article ,
"Ken Loomis" wrote:

Can anyone suggest a way to convert a date that looks like this:

6/23/2005

to

062305


Thanks in advanced.

Ken