No. The formats could be different. That's what the FormatFieldValue is for.

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