Dmitry,

Use the Transform() function with the @E parameter.

Bill Anderson
The Anderson Files LLC

>>>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
>
>Thank you.