How to Convert a Date to a Specific Text Format-Deadline Near

[TSimonick]

Hi,

I'm converting a tables and need to change dates to plain text strings:

6/4/2002 to 060402
11/9/2000 to 110900

Anyone can help on the code I'd appreciate it!!

Thanks,

Tom

 

[TSimonick]

Sorry, need to clarify (tired mind). When I use DatePart I'm getting a space that I can't figure out a way to remove. For example "0"&(str$(DatePart("m", "9/02/04&quot)) produces 0 9. There is always a space preceeding the value of DatePart.

Any ideas?

Thanks,

Tom

 

[danvlas]

Format(Month(YourDate),"00&quot & Format(Day(YourDate),"00&quot & Right(Year(YourDate),2)

should return what you want (in mmddyy format)...

Good luck

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[TSimonick]

Thanks Daniel, that will work fine!

Regards,

Tom