Convert '6/23/2005' to '062305'
 

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

6/23/2005

to

062305


Thanks in advanced.

Ken

Convert '6/23/2005' to '062305'
 

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

Convert '6/23/2005' to '062305'
 

Thanks,

That is so much more elegant then the character at a time programming I was
trying.

Ken


"JE McGimpsey" wrote in message
...
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