Conversions
Function
CBool(expression)
CByte(expression)
CCur(expression)
CDate(expression)
CDbl(expression)
CInt(expression)
CLng(expression)
CSng(expression)
CStr(expression)
Description
The conversion functions return an expression that has been converted to the appropriate type. The required parameter, expression, is any valid expression.
If the return value lies outside the acceptable range of its return type, an error occurs.
Table 5: Conversion Functions
| Function | Returns | Comments |
|---|---|---|
| CBool | Boolean | False if expression is zero True otherwise |
| CByte | Byte | A whole number that ranges from 0 to 255 |
| CCur | Currency | A Currency Datum |
| CDate | Date | Date range January 1, 100 to December 31, 9999,
Valid expressions are date expressions, or date/time literals |
| CDbl | Double | Number ranges from
-1.79769313486232E308 to -4.94065645841247E-324 for negative values, and from 4.94065645841247E-324 to 1.79769313486232E308 for positive values |
| CInt | Integer | Number ranges from -32,768 to 32,767, values with fractional parts (fp) are rounded
fp < 0.5 rounded down fp > 0.5 rounded up fp = 0.5 rounded to nearest even number |
| CLng | Long Integer | Number ranges from
-2,147,483,648 to 2,147,483,647, values with fractional parts (fp) are rounded fp < 0.5 rounded down fp > 0.5 rounded up fp = 0.5 rounded to nearest even number |
| CSng | Single | Number ranges from
-3.403823E38 to -1.401298E-45 for negative numbers, and from 1.401298E-45 to 3.403823E38 for positive numbers |
| CStr | String | •Booleans are converted to "True" or "False"
•Dates converted to short-date format of system •Errors converted to "Error <number>" •Numbers converted to string containing the number |
Example
REM Conversion Functions Example
PRINT "CByte(99.44) = " & CByte(99.44)
PRINT "CCur(9283.066) = " & CCur(9283.066)
PRINT "CDate(8/18/98) = " & CDate("8/18/98")
PRINT "CDbl(3.141593) = " & CDbl("3.141593")
PRINT "CInt(3.141593) = " & CInt("3.141593")
PRINT "CSng(10) = " & CSng(10)
PRINT "CStr(TRUE) = " & CStr(TRUE)
Output
CByte(99.44) = 99 CCur(9283.066) = 9283.066 CDate(8/18/98) = 8/18/1998 CDbl(3.141593) = 3.141593 CInt(3.141593) = 3 CSng(10) = 10 CStr(TRUE) = True