My question is how do you change the format date to another format date.
for example: in my file all date like this:2009/09/14 but i want to convert to
2009-09-14 ofcourse i have done like following but noting happen:


1-Select Date in the Category list.
2- Select a date format in the Type list.

Does anyone know how to do this? If anyone can offer any suggestions about
how to convert date I'd love to hear them.

Thanks, ashrafi

Assuming that the field in which the dates are stored is a Date field, you
do not need to do anything to the data itself. Just change the Format that
is assigned to the field.

yyyy-mm-dd


--

Ken Snell
http://www.accessmvp.com/KDSnell/


"ashrafi" <(E-Mail Removed)> wrote in message
news736B8A8-FD20-49EC-8609-(E-Mail Removed)...
>
>
> My question is how do you change the format date to another format date.
> for example: in my file all date like this:2009/09/14 but i want to
> convert to
> 2009-09-14 ofcourse i have done like following but noting happen:
>
>
> 1-Select Date in the Category list.
> 2- Select a date format in the Type list.
>
> Does anyone know how to do this? If anyone can offer any suggestions about
> how to convert date I'd love to hear them.
>
> Thanks, ashrafi
>
>