VBScript Data Type Convertion Functions

Functions for manipulating data type of expression.

CDate Function

Create a Date data subtype value from a given expression.

Syntax

CDate(date)

Argument

Returns

Returns of function:

Special returns of function:

Remarks

• CDate function convert a given expression to a Variant of Date data subtype by evaluate the CDate result of the given expression.
• CDate function returns Run-time error for any invalid given expression.
• The valid range of date return by CDate function is between January 1, 100 12:00:00 AM and December 31, 9999 11:59:59 PM inclusive.The preset zero-date is also #12/30/1899 12:00:00 AM#.
• A Boolean expression contains True result is converted to a Date containing 12/29/1899.
• A Boolean expression contains False result is converted to a Date containing 12:00:00 AM.
• CDate function returns 12:00:00 AM if a given expression contains Empty. However, CDate function returns Run-time error if a given expression contains zero-length string, "".
• Besides date literals and time literals, CDate function also recognizes dates formats.The conversion of CDate function uses local system settings to determine the format of conversion, such as decimal separators, or thousand separators when necessary.
• In general, CDate function using the same date and time recognization method.
• A date with day of week will also cause CDate function to return Run-time error. However, numeric expression of date argument is considered as number of day with respect to the zero-date. The whole number portion is converted to a date by adding the number of day to date part of zero-date accordingly. Any fractional part of the numeric expression is converted to a time of day by adding the fractional time of day to the time part of zero-date accordingly.

Requirement

CBool Function

Create a Boolean result value of a given expression.

Syntax

CBool(expression)

Argument

Returns

Returns of function:

Special returns of function:

Remarks

• Cbool function convert a given expression to a Variant of Boolean data subtype by evaluate the Boolean result of the given expression.
• Cbool function returns True for a valid result of the given expression.
• Cbool function returns False for an invalid result of the given expression.
• Cbool function returns Run-time error for any invalid given expression.
• A String contains "true" is equal to a Boolean contain True result.
• A String contains "false" is equal to a Boolean contain False result.
• Cbool function returns a False Boolean result if a given expression contains Empty. However, Cbool function returns Run-time error if a given expression contains zero-length string, "".
• In general if an expression cannot be interpreted as a numeric value, except the key words True and False, CBool function returns Run-time erroc.
• For any numeric expression, CBool function returns False result only for the given expression equals to zero, but for the given expression not equals to zero, CBool function returns False result.

Requirement

CByte Function

Create a Byte data subtype value from a given expression.

Syntax

CByte(expression)

Argument

Returns

Returns of function:

Special returns of function:

Remarks

• Cbyte function convert a given expression to a Variant of Byte data subtype by evaluate the Byte result of the given expression.
• Cbyte function returns number between 0 and 255 for a valid result of the given expression.
• Cbyte function returns Run-time error for any invalid given expression.
• A Boolean expression contains True result is converted to a Byte containing 255.
• A Boolean expression contains False result is converted to a Byte containing 0.
• CByte function returns 0 if a given expression contains Empty. However, CByte function returns Run-time error if a given expression contains zero-length string, "".
• In general, if an expression cannot be interpreted as a boolean value or a numeric value between 0 and 255 inclusive, CByte function returns Run-time erroc.
• The conversion of CByte function forces other data type arithmetic, such as currency, single-precision, double-precision, or integer arithmetic to byte type arithmetic only.
• The conversion of CByte function uses local system settings to determine the format of conversion, such as decimal separators, or thousand separators when necessary.

Requirement

CCur Function

Create a Currency data subtype value from a given expression.

Syntax

CCur(expression)

Argument

Returns

Returns of function:

Special returns of function:

Remarks

• CCur function convert a given expression to a Variant of Currency data subtype by evaluate the CCur result of the given expression.
• CCur function returns Run-time error for any invalid given expression.
• A Boolean expression contains True result is converted to a Currency containing -1.
• A Boolean expression contains False result is converted to a Currency containing 0.
• CCur function returns 0 if a given expression contains Empty. However, CCur function returns Run-time error if a given expression contains zero-length string, "".
• In general, if an expression cannot be interpreted as a boolean value or a numeric value, CCur function returns Run-time erroc.
• The conversion of CCur function forces other data type arithmetic, such as byte, single-precision, double-precision, or integer arithmetic to currency type arithmetic only.
• The conversion of CCur function uses local system settings to determine the format of conversion, such as decimal separators, or thousand separators when necessary.

Requirement

CDbl Function

Create a Double data subtype value from a given expression.

Syntax

CDbl(expression)

Argument

Returns

Returns of function:

Special returns of function:

Remarks

• CDbl function convert a given expression to a Variant of Double data subtype by evaluate the CDbl result of the given expression.
• CDbl function returns Run-time error for any invalid given expression.
• A Boolean expression contains True result is converted to a Double containing -1.
• A Boolean expression contains False result is converted to a Double containing 0.
• CDbl function returns 0 if a given expression contains Empty. However, CDbl function returns Run-time error if a given expression contains zero-length string, "".
• The conversion of CDbl function forces other data type arithmetic, such as byte, single-precision, currency, or integer arithmetic to double-precision type arithmetic only.
• The conversion of CDbl function uses local system settings to determine the format of conversion, such as decimal separators, or thousand separators when necessary.

Requirement

CSng Function

Create a Single data subtype value from a given expression.

Syntax

CSng(expression)

Argument

Returns

Returns of function:

Special returns of function:

Remarks

• CSng function convert a given expression to a Variant of Single data subtype by evaluate the CSng result of the given expression.
• CSng function returns Run-time error for any invalid given expression.
• A Boolean expression contains True result is converted to a Single containing -1.
• A Boolean expression contains False result is converted to a Single containing 0.
• CSng function returns 0 if a given expression contains Empty. However, CSng function returns Run-time error if a given expression contains zero-length string, "".
• The conversion of CSng function forces other data type arithmetic, such as byte, Double-precision, currency, or integer arithmetic to Single-precision type arithmetic only.
• The conversion of CSng function uses local system settings to determine the format of conversion, such as decimal separators, or thousand separators when necessary.

Requirement

CLng Function

Create a Long data subtype value from a given expression.

Syntax

CLng(expression)

Argument

Returns

Returns of function:

Special returns of function:

Remarks

• CLng function convert a given expression to a Variant of Long data subtype by evaluate the CLng result of the given expression.
• CLng function returns Run-time error for any invalid given expression.
• The return value of CLng function is alway rounded to an integer.
• A Boolean expression contains True result is converted to a Long containing -1.
• A Boolean expression contains False result is converted to a Long containing 0.
• CLng function returns 0 if a given expression contains Empty. However, CLng function returns Run-time error if a given expression contains zero-length string, "".
• The conversion of CLng function forces other data type arithmetic, such as byte, Single-precision, Double-precision, currency, or integer arithmetic to Long type arithmetic only.
• The conversion of CLng function uses local system settings to determine the format of conversion, such as decimal separators, or thousand separators when necessary.

Requirement

CInt Function

Create an Integer data subtype value from a given expression.

Syntax

CInt(expression)

Argument

Returns

Returns of function:

Special returns of function:

Remarks

• CInt function convert a given expression to a Variant of Integer data subtype by evaluate the CInt result of the given expression.
• CInt function returns Run-time error for any invalid given expression.
• The return value of CInt function is always rounded to an integer.
• A Boolean expression contains True result is converted to a Integer containing -1.
• A Boolean expression contains False result is converted to a Integer containing 0.
• CInt function returns 0 if a given expression contains Empty. However, CInt function returns Run-time error if a given expression contains zero-length string, "".
• The conversion of CInt function forces other data type arithmetic, such as byte, Single-precision, Double-precision, currency, or Long arithmetic to Integer type arithmetic only.
• The conversion of CInt function uses local system settings to determine the format of conversion, such as decimal separators, or thousand separators when necessary.

Requirement

CStr Function

Create a String data subtype value from a given expression.

Syntax

CStr(expression)

Argument

Returns

Returns of function:

Special returns of function:

Remarks

• CStr function convert a given expression to a Variant of String data subtype by evaluate the CStr result of the given expression.
• CStr function returns Run-time error for any invalid given expression.
• A Boolean expression contains True result is converted to a String containing True.
• A Boolean expression contains False result is converted to a String containing Fasle.
• CStr function returns a zero-length string "", if a given expression contains Empty or zero-length string, "".
• The conversion of CStr function uses local system settings to determine the format of conversion, such as decimal separators, or thousand separators when necessary.

Requirement

Examples

Examples of CDate, CBool, CByte, CCur, CDbl, CSng, CLng, CInt, CStr functions

<script runat="server" language="VBScript">
Dim vars,strs,cmda
cmda=array("strs","CDate(strs)","CBool(strs)","CByte(strs)","CCur(strs)","CDbl(strs)","CSng(strs)","CLng(strs)","CInt(strs)","CStr(strs)")
Dim ucnt,tmp,i:ucnt=UBound(cmda):If var=1 Then:tmp="":Else:tmp="<b>vars</b>":End If:For i=0 to ucnt:tmp=tmp&"<b>"&rmv_ctrl(cmda(i))&", TypeName</b>":Next:Response.Write "Results on Microsoft Windows 8.1 Pro x64, Microsoft-IIS/8.5, VBScript Version 5.8 of page /internet/users/sideblog/default.asp<br />"&"<i>"&tmp&"</i>"
Function dsp_x:Dim tmp_a,tmp_b,i:If varx=0  Then:Execute vars:End If:If var=1 Then:tmp_a="":Else:tmp_a=rmv_ctrl(vars):End If:For i=0 to ucnt:tmp_b=cmd_b(cmda(i)):if i/2=fix(i/2) Then:tmp_b="<b>"&tmp_b&"</b>":End If:tmp_a=tmp_a&tmp_b:Next:Response.Write "<i>"&tmp_a&"</i>":End Function
Function rmv_ctrl(blk_str):Select Case blk_str:Case chr(0):blk_str="NUL":Case chr(1):blk_str="SOH":Case chr(2):blk_str="STX":Case chr(3):blk_str="ETX":Case chr(4):blk_str="EOT":Case chr(5):blk_str="ENQ":Case chr(6):blk_str="ACK":Case chr(7):blk_str="BEL":Case chr(8):blk_str="BS":Case chr(9):blk_str="HT":Case chr(10):blk_str="LF":Case chr(11):blk_str="VT":Case chr(12):blk_str="FF":Case chr(13):blk_str="CR":Case chr(14):blk_str="SO":Case chr(15):blk_str="SI":Case chr(16):blk_str="DLE":Case chr(17):blk_str="DC1":Case chr(18):blk_str="DC2":Case chr(19):blk_str="DC3":Case chr(20):blk_str="DC4":Case chr(21):blk_str="NAK":Case chr(22):blk_str="SYN":Case chr(23):blk_str="ETB":Case chr(24):blk_str="CAN":Case chr(25):blk_str="EM":Case chr(26):blk_str="SUB":Case chr(27):blk_str="ESC":Case chr(28):blk_str="FS":Case chr(29):blk_str="GS":Case chr(30):blk_str="RS":Case chr(31):blk_str="US":Case chr(127):blk_str="DEL":End Select:rmv_ctrl=blk_str:If IsNull(blk_str) OR IsEmpty(Blk_str) OR blk_str="" OR IsNumeric(Blk_str) Then:Else:rmv_ctrl=Replace(Replace(Replace(Replace(Replace(blk_str,"&","&amp;"),"  "," &nbsp;"),"""","&quot;"),"<","&lt;"),">","&gt;"): End If :End Function
Function cmd_b(blk_str):cmd_b="["&cmd_x(blk_str)&"], "&cmd_x("TypeName("&blk_str&")"):End Function
Function cmd_x(blk_str):On Error Resume Next:Dim xans, tmp:xans="":tmp="":execute "xans="&blk_str:If Err.Number <> 0  Then:xans=cmd_x("TypeName("&blk_str&")"):Select Case xans:Case 9::Case Else:xans="error":End Select:End If:If IsArray(xans)=False Then:cmd_x=rmv_ctrl(xans): Else:tmp=lst_arry(xans):cmd_x=trim(tmp):End If:End Function
Function lst_arry(blk_str):Dim tmp,i,q:q="""":tmp="":For i=0 to UBound(blk_str):if VarType(blk_str(i))>1 And VarType(blk_str(i))<6 Then:q="'":End If:tmp=tmp&" "&q&rmv_ctrl(blk_str(i))&q:Next:lst_arry=trim(tmp):End Function

vars="Set strs = CreateObject(""vbscript.regexp"")":dsp_x
vars="Set strs = ObjectContext":dsp_x
vars="strs=Null":dsp_x
vars="strs=Empty":dsp_x
vars="strs=""""":dsp_x
vars="strs=Null & Null":dsp_x
vars="strs=Null & Empty":dsp_x
vars="strs=Null & True":dsp_x
vars="strs=Null & (1=1)":dsp_x
vars="strs=Null & False":dsp_x
vars="strs=Empty & Empty":dsp_x
vars="strs=Empty & True":dsp_x
vars="strs=Empty & False":dsp_x
vars="strs=Empty & 4":dsp_x
vars="strs=Null & 4":dsp_x
vars="strs=Null Or Null":dsp_x
vars="strs=Null Or Empty":dsp_x
vars="strs=Null Or True":dsp_x
vars="strs=Null Or (1=1)":dsp_x
vars="strs=Null Or False":dsp_x
vars="strs=Empty Or Empty":dsp_x
vars="strs=Empty Or True":dsp_x
vars="strs=Empty Or False":dsp_x
vars="strs=Empty+Null":dsp_x
vars="strs=Empty+Empty":dsp_x
vars="strs=Empty+4":dsp_x
vars="strs=Null+Null":dsp_x
vars="strs=Null+4":dsp_x
vars="tmp=Null:strs=tmp=Null":dsp_x
vars="tmp=Null:strs=tmp<>Null":dsp_x
vars="tmp=Empty:strs=tmp=Null":dsp_x
vars="tmp=Empty:strs=tmp<>Null":dsp_x
vars="strs=(tmp=Null)":dsp_x
vars="strs=(tmp<>Null)":dsp_x
vars="tmp_arry=Array(1,2):strs=tmp_arry":dsp_x
vars="tmp_arry=Split(""1 2""):strs=tmp_arry":dsp_x
vars="strs=Array(1,2)":dsp_x
vars="strs=""Array(1,2)""":dsp_x
vars="strs=Split(""1 2"")":dsp_x
vars="strs=""Split(""""1 2"""")""":dsp_x
vars="strs=Now":dsp_x
vars="strs=Date":dsp_x
vars="strs=Time":dsp_x
vars="strs=""1.3.3""":dsp_x
vars="strs=""1.3.3 AM""":dsp_x
vars="strs=""1.3.3 PM""":dsp_x
vars="strs=""21.3.3""":dsp_x
vars="strs=#1:3:3#":dsp_x
vars="strs=#1.3.3#":dsp_x
vars="strs=""1,3,3""":dsp_x
vars="strs=""1,Apr,3""":dsp_x
vars="strs=""51,Apr,3""":dsp_x
vars="strs=""1,April,3""":dsp_x
vars="strs=""11.3.3 1,3,3""":dsp_x
vars="strs=""1,Apr,3 1.3.3""":dsp_x
vars="strs=""11.3.3 51,Apr,3""":dsp_x
vars="strs=""1,April,3 11.3.3""":dsp_x
vars="strs=#1/3/3#":dsp_x
vars="strs=#1,3,3#":dsp_x
vars="strs=#1-3-3#":dsp_x
vars="strs=#1 3 3#":dsp_x
vars="strs=CBool(1)":dsp_x
vars="strs=CBool(0)":dsp_x
vars="strs=True":dsp_x
vars="strs=true":dsp_x
vars="strs=False":dsp_x
vars="strs=false":dsp_x
vars="strs=""True""":dsp_x
vars="strs=""true""":dsp_x
vars="strs=""False""":dsp_x
vars="strs=""false""":dsp_x
vars="strs=""1""":dsp_x
vars="strs=""0""":dsp_x
vars="strs=""254""":dsp_x
vars="strs=""254.4""":dsp_x
vars="strs=""254.5""":dsp_x
vars="strs=""254.6""":dsp_x
vars="strs=-1.79769313486231E308":dsp_x
vars="strs=-922337203685477.5809":dsp_x
vars="strs=-2147483649":dsp_x
vars="strs=-32769":dsp_x
vars="strs=-4.94065645841247E-324":dsp_x
vars="strs=4.94065645841247E-324":dsp_x
vars="strs=32768":dsp_x
vars="strs=2147483648":dsp_x
vars="strs=922337203685477.5808":dsp_x
vars="strs=1.79769313486231E308":dsp_x
vars="strs=Yes":dsp_x
vars="strs=No":dsp_x
vars="strs=1":dsp_x
vars="strs=1.1":dsp_x
vars="strs=2.1":dsp_x
vars="strs=0":dsp_x
vars="strs=-0":dsp_x
vars="strs=-0.39":dsp_x
vars="strs=-0.399":dsp_x
vars="strs=-0.4":dsp_x
vars="strs=-0.401":dsp_x
vars="strs=-0.5":dsp_x
vars="strs=-0.45":dsp_x
vars="strs=-4":dsp_x
vars="strs=4":dsp_x
vars="strs=4.4":dsp_x
vars="strs=5.5":dsp_x
vars="strs=4.6":dsp_x
vars="strs=0.4":dsp_x
vars="strs=0.5":dsp_x
vars="strs=0.6":dsp_x
vars="strs=254":dsp_x
vars="strs=254.4":dsp_x
vars="strs=254.5":dsp_x
vars="strs=254.6":dsp_x
vars="strs=255":dsp_x
vars="strs=CByte(255)":dsp_x
vars="strs=255.4":dsp_x
vars="strs=256":dsp_x
vars="strs=32255.4":dsp_x
vars="strs=1E4":dsp_x
vars="strs=5/6":dsp_x
vars="strs=6/6":dsp_x
vars="strs=0/6":dsp_x
vars="strs=6-6":dsp_x
vars="strs=5=6":dsp_x
vars="strs=6=6":dsp_x
vars="strs=5>6":dsp_x
vars="strs=5<6":dsp_x
vars="strs=5.5-3.5":dsp_x
vars="strs=5.5+3.5":dsp_x
vars="strs=100.5-55.9":dsp_x
vars="strs=100.5+55.9":dsp_x
vars="strs=CCur(51235/6)":dsp_x
vars="strs=CDbl(51235/6)":dsp_x
vars="strs=CSng(51235/6)":dsp_x
vars="strs=CLng(51235/6)":dsp_x
vars="strs=CInt(51235/6)":dsp_x
vars="strs=CStr(51235/6)":dsp_x
vars="strs=CByte(51/6)":dsp_x
vars="strs=CBool(51/6)":dsp_x
vars="strs=CCur(5.5)+CCur(3.5)":dsp_x
vars="strs=CCur(5.5)+CDbl(3.5)":dsp_x
vars="strs=CCur(5.5)+CSng(3.5)":dsp_x
vars="strs=CCur(5.5)+CLng(3.5)":dsp_x
vars="strs=CCur(5.5)+CInt(3.5)":dsp_x
vars="strs=CCur(5.5)+CByte(3.5)":dsp_x
vars="strs=CCur(5.5)+CBool(3.5)":dsp_x
vars="strs=CCur(5.5)+CStr(3.5)":dsp_x
vars="strs=CDbl(5.5)+CCur(3.5)":dsp_x
vars="strs=CDbl(5.5)+CDbl(3.5)":dsp_x
vars="strs=CDbl(5.5)+CSng(3.5)":dsp_x
vars="strs=CDbl(5.5)+CLng(3.5)":dsp_x
vars="strs=CDbl(5.5)+CInt(3.5)":dsp_x
vars="strs=CDbl(5.5)+CByte(3.5)":dsp_x
vars="strs=CDbl(5.5)+CBool(3.5)":dsp_x
vars="strs=CDbl(5.5)+CStr(3.5)":dsp_x
vars="strs=CSng(5.5)+CCur(3.5)":dsp_x
vars="strs=CSng(5.5)+CDbl(3.5)":dsp_x
vars="strs=CSng(5.5)+CSng(3.5)":dsp_x
vars="strs=CSng(5.5)+CLng(3.5)":dsp_x
vars="strs=CSng(5.5)+CInt(3.5)":dsp_x
vars="strs=CSng(5.5)+CByte(3.5)":dsp_x
vars="strs=CSng(5.5)+CBool(3.5)":dsp_x
vars="strs=CSng(5.5)+CStr(3.5)":dsp_x
vars="strs=CLng(5.5)+CCur(3.5)":dsp_x
vars="strs=CLng(5.5)+CDbl(3.5)":dsp_x
vars="strs=CLng(5.5)+CSng(3.5)":dsp_x
vars="strs=CLng(5.5)+CLng(3.5)":dsp_x
vars="strs=CLng(5.5)+CInt(3.5)":dsp_x
vars="strs=CLng(5.5)+CByte(3.5)":dsp_x
vars="strs=CLng(5.5)+CBool(3.5)":dsp_x
vars="strs=CLng(5.5)+CStr(3.5)":dsp_x
vars="strs=CInt(5.5)+CCur(3.5)":dsp_x
vars="strs=CInt(5.5)+CDbl(3.5)":dsp_x
vars="strs=CInt(5.5)+CSng(3.5)":dsp_x
vars="strs=CInt(5.5)+CLng(3.5)":dsp_x
vars="strs=CInt(5.5)+CInt(3.5)":dsp_x
vars="strs=CInt(5.5)+CByte(3.5)":dsp_x
vars="strs=CInt(5.5)+CBool(3.5)":dsp_x
vars="strs=CInt(5.5)+CStr(3.5)":dsp_x
vars="strs=CByte(5.5)+CCur(3.5)":dsp_x
vars="strs=CByte(5.5)+CDbl(3.5)":dsp_x
vars="strs=CByte(5.5)+CSng(3.5)":dsp_x
vars="strs=CByte(5.5)+CLng(3.5)":dsp_x
vars="strs=CByte(5.5)+CInt(3.5)":dsp_x
vars="strs=CByte(5.5)+CByte(3.5)":dsp_x
vars="strs=CByte(5.5)+CBool(3.5)":dsp_x
vars="strs=CByte(5.5)+CStr(3.5)":dsp_x
vars="strs=CBool(5.5)+CCur(3.5)":dsp_x
vars="strs=CBool(5.5)+CDbl(3.5)":dsp_x
vars="strs=CBool(5.5)+CSng(3.5)":dsp_x
vars="strs=CBool(5.5)+CLng(3.5)":dsp_x
vars="strs=CBool(5.5)+CInt(3.5)":dsp_x
vars="strs=CBool(5.5)+CByte(3.5)":dsp_x
vars="strs=CBool(5.5)+CBool(3.5)":dsp_x
vars="strs=CBool(5.5)+CStr(3.5)":dsp_x
vars="strs=CStr(5.5)+CCur(3.5)":dsp_x
vars="strs=CStr(5.5)+CDbl(3.5)":dsp_x
vars="strs=CStr(5.5)+CSng(3.5)":dsp_x
vars="strs=CStr(5.5)+CLng(3.5)":dsp_x
vars="strs=CStr(5.5)+CInt(3.5)":dsp_x
vars="strs=CStr(5.5)+CByte(3.5)":dsp_x
vars="strs=CStr(5.5)+CBool(3.5)":dsp_x
vars="strs=CStr(5.5)+3.5":dsp_x
</script>