Val
Expression = Val ( String )
Convert a string into a boolean, a number or a date, according to the string contents.
The current localization is used for converting numbers and dates.
So beware that date, time, decimal and thousands separators change with the language!
The conversion algorithm is the following:

If the string can be interpreted as a date & time (with date or time separators), then the date & time is returned.

Else, if the string can be interpreted as a floating point number, then this floating point number is returned.

Else, if the string can be interpreted as a 64 bits long number, then this long number is returned.

Else, if the string can be interpreted as an integer number, then this integer number is returned.

Else, if the string is "True"
or "False"
, then the matching boolean value is returned.

Otherwise, NULL is returned.
Examples
Print Val("09/06/72 01:00")
Print Val("&H123abc") ' &H indicates HEX number
Print IsNull(Val("Gambas"))
See also