Convert format of date

[ashrafi]

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

 

[Ken Snell]

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