Dmitry,

Yeah, you're right, sorry about that.

Bill Anderson
The Anderson Files LLC

>Thank you, Bill,
>
>From what I understand, the TRANSFORM with @E parameter converts an American Date to British. I needed the opposite, convert a British Date to American.
>
>>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.