>Hi,
>
>Can you change the date from British to American using SET DATE command?
>
>For example, say you have a char column in a DBF like this:
>14/10/2020
>08/03/2012
>16/2/2020
>3/3/2010
>all the above characters show the date in a British format. Note the above are not dates but char representation of a date.
>Now I want to change them to American format (mm/dd/yyyy)
>Can it be done without many SUBSTR()?
>
>TIA

At first I thought DTOC() would have a parameter for using a particular SET DATE setting. But I was wrong. But if this were a one time thing I would do something like

SCAN
SET DATE BRITISH
ldDate = CTOD(myField)
SET DATE AMERICAN
REPLACE myField WTIH DTOC(ldDate)
ENDSCAN

Not very elegant (dBase III style), but simple