|
Syntax |
VAL(Text) |
|
Description |
Returns number in text as data type Number, for use with formulas involving numbers or numeric functions. |
|
Example |
VAL ("123") => 123 |
|
Text |
Any text expression or data field containing a text to be converted to a numeric value. |
You can use this function to convert text fields to fields that hold a value.
If you have a text field that holds number characters, you can convert that field so you can do calculations with it.
Example:
The field [COUPON] holds a text, (for example, "7")
VAL([COUPON])/365 => 0.02