Conversion Functions

The following Visual Basic commands have been tested with IDEA v9 and appear to be functioning properly. I have added some examples where possible on their use.


The Asc() function will return the ASCII code for the character.  It a string is placed in the function it will only return the ASCII code for the first character.


Converst an expression into a boolean.  So if the expression is true, i.e. 5 = 5 then it would return True, if it is false, i.e. 5 = 6 then it would return false.


This function converst a valid date or time expression that is currently a string into a date type.  The expression can contain only the date, only the time or both.


This conversion will change a number into a number of type double.


Converts a numeric expression into one of an integer data type.  In the example below when we changed a double into an integer the fractional portion is rounded.


This functions changes a number into a long type.


This function will change a number into a single type.  A single type has 4 decimals so any decimals larger than 4 will be rounded to 4.


The CStr() will convert numeric and date values to a string format.