Oscar, I found that the only way to convert 5.x currency data to 6/7.x is to import it to a character field and then from the char to the 6/7.x currency field.
Rick Sent from my Verizon Wireless BlackBerry -----Original Message----- From: Oscar Herrera <[email protected]> Date: Thu, 19 Mar 2009 09:31:51 To: <[email protected]> Subject: AIE and Currency fields I wonder if any has seen this in AIE and found a soloution. I'm migrating custom forms with currency fields from remedy 5 environment into Compponents class (CMD 2.1) in ars 7.1 The currency fields have a structural difference from the 7.1 environment and thus my mappings are failing. See below: 7.1 Env CurrencyField 5.5 Env: CurrencyFieldV CurrencyFieldC CurrencyFieldD I haven't found the proper syntax either in a concatenate or IF statement to make the currency field come in Here's and example of what I've tried: STMT| IF CurrencyFieldV != ".00000000" THen Currencyfieldfield = "0.00" End IF Function|Concat(currencyfieldV, "00000000") I appreciate any suggestions Thanks in advance, Oscar Herrera _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
