I need to have the date separator to be a "/" instead of a "-" in a datetime field.

TABLE FILE FILE1
STDVALUEEFFECTIVEDATE
COMPUTE TEMP3/HMDYI = STDVALUEEFFECTIVEDATE;
END

Result:

STDVALUEEFFECTIVEDATE TEMP3
2004-10-01 06:00:00 10-01-04 06:00

I need the format to be 10/01/04 06:00

Thanks in advance.

It could be your setting of DTSTANDARD.

A setting of ON/STANDARD/STANDARDU gives ISO compatability and uses the '-' as a date seperator.

Try issuing SET DTSTANDARD=OFF to get the '/' in the date portion.

Thanks Alan, it worked!