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.
IDEA is a trademark of CaseWare International Inc., used by permission.
All material provided on the IDEAScripting website is presented as is without any warranty or guarantee. Anybody using any solution provided on this pages is encouraged to validate the effectiveness and reliability on their own.
IDEA Help Videos
IDEA Related Videos
IDEA Success Stories