Skip to main content

Conversion

CSng()

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.

CInt()

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.

CDate()

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.

Cbool()

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.

Asc()

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.