Within C/AL, I know that you can convert a value to a string by using: FORMAT(value) However, is there a way to convert a string to a value? Obviously, if the string contains non-numeric characters then an error would be returned. This is as expected and as required. Many Thanks, Simon
Then you are looking for EVALUATE.
You can use evaluate! EVALUATE(“DECIMAL FIELD”,STRINGVALUE);
DUH!!! Well, I am new to navision. [:I] Thanks very much.
Unfortunately EVALUATE command relies on strings in the format set by the regional settings of the PC where the command is being executed. Rather than the Format command where you can create your own format string (i.e. decimal point, sign at the beginning or at the end, using a space or a dot or a comma as thousands seperator).