If you are simply talking about how a date is displayed:

If it is formatted as yyy/mm/dd, Format as yyymmdd

If it is formatted as yyy/dd/mm, Format as yyyddmm

(I can't tell from the example)

Regards

Trevor


"EdJack" wrote in message
...
How do I change "2006/10/02" to "20061002"