xlate (OpenInsight 32-Bit)
At 28 JUN 2007 09:01:55PM Jim Vaughan wrote:
If I grab a value from a calculated field using xlate() the returned value seems to ignore the output conversion set on the field in the calculated column attributes (DT in the example I am testing). Instead of getting a date I get a numeric value.
(1) Is this correct?
(2) If it is, how do I find out what the setting for output conversion is so that I can apply it myself?
At 28 JUN 2007 11:09PM Bob Carten wrote:
If I grab a value from a calculated field using xlate() the returned value seems to ignore the output conversion set on the field in the calculated column attributes (DT in the example I am testing). Instead of getting a date I get a numeric value.
(1) Is this correct?
Yes.
(2) If it is, how do I find out what the setting for output conversion is so that I can apply it myself?
See Dict_Equates. You can use the "%FIELDS%" rec in the dict plus a locate to find the conversion for a column by name or number.
At 29 JUN 2007 02:59AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Or just Xlate to the dict :)
World leaders in all things RevSoft
At 29 JUN 2007 03:25PM Jim Vaughan wrote:
Perfect, that was easy.
Thanks to both of you.