No, that was intentional. I was just hoping someone would give me a clue in one of them how to handle the different formats. They all are basically the OTHERWISE condition right now.

>Jay,
>
>Copy/paste code error? all of the expressions are identical... I'd hope they all give the same result *g*
>
>>I'm having trouble getting the NewFieldValue to evaluate to the correct character value. Can someone give me an example of what I need to do in one of the CASE conditions?
>>

>>
>>FieldValue = {^2008/01/01}
>>
>>DO CASE
>>	CASE FormatFieldValue = 'CCYYMMDD' && Should be "20080101"
>>		NewFieldValue = EVALUATE("ALLTRIM(TRANSFORM(DTOS(FieldValue), '@R " + REPLICATE('!',FieldLength) + "'))")
>>	CASE FormatFieldValue = 'MMDDCCYY' && Should be "01012008"
>>		NewFieldValue = EVALUATE("ALLTRIM(TRANSFORM(DTOS(FieldValue), '@R " + REPLICATE('!',FieldLength) + "'))")
>>	OTHERWISE && Leave it alone other than converting to text
>>		NewFieldValue = EVALUATE("ALLTRIM(TRANSFORM(DTOS(FieldValue), '@R " + REPLICATE('!',FieldLength) + "'))")
>>ENDCASE
>>