How to convert text to a number??

Business Central/NAV User Forum
1

I know how to turn a number or date to a text field with the FORMAT command but is there a way to convert a text to a number field?? There are some fields I’d like to total but can’t because their text.

Thanks in advance,

Greg

2

You can use the EVALUATE function for this. See the helpinfo about this function.

Value := ‘010196’;
Ok1 := EVALUATE(VarInteger, Value);
Ok2 := EVALUATE(VarDate, Value);
Ok3 := EVALUATE(VarYesNo, Value);

3

Use evaluate

if evaluate(Number,Text) then …