And why you want from date to get date?
Isn't just:

NewFieldValue = FieldValue 

enough?


>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
>>>