Expression = Val ( String )

Converts 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 a 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.

Example