Sideway BICK BlogSideway BICK BLOG from Sideway

A Sideway to Sideway Home
Home
Output.to

Link:http://output.to/sideway/default.asp?qno=180300018

Script, Scripting Language, VBScript elements, Server-Side VBScript Function FormatCurrency, FormatDateTime, FormatNumber, FormatPercent Function

VBScript String Functions

Functions for manipulating string expression.

FormatNumber Function

last updated 9/18/2017

Create a string of a formatted number value expression from a given numeric or is evaluated as numeric expression according to local system settings and specified arguments.

Syntax

FormatNumber(Expression [,NumDigitsAfterDecimal [,IncludeLeadingDigit
    [,UseParensForNegativeNumbers [,GroupDigits]]]])

Argument

ExpressionRequired. Expression to be formatted.NumDigitsAfterDecimalOptional. Numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the local computer's regional settings are used.IncludeLeadingDigitOptional setting. Tristate constant that indicates whether or not a leading zero is displayed for fractional values. UseParensForNegativeNumbersOptional setting. Tristate constant that indicates whether or not to place negative values within parentheses. GroupDigitsOptional setting. Tristate constant that indicates whether or not numbers are grouped using the group delimiter specified in the local computer's regional settings.

Settings

IncludeLeadingDigit, UseParensForNegativeNumbers, and GroupDigits arguments

vbConstantValueDescriptionvbUseDefault-2Use default from computer's regional settings.vbTrue-1TruevbFalse0False

Returns

Returns a Variant of the String data subtype containing a string of a formatted number value expression from a given numeric or is evaluated as numeric expression according to local system settings and specified arguments.

Special returns of FormatNumber function:

numberreturn valueNullRun-time ErrorEmptye.g. 0.00""Run-time Error

Remarks

  • The number value of NumDigitsAfterDecimal arguments can be any valid numeric expression greater than or equal to -1.4 and is equal to Round(NumDigitsAfterDecimal)
  • The rounding of the numeric value of Expression use theround to nearest method but following the round half away from zero rule, not the round half to even rule used in Round function.
  • When one or more optional arguments are omitted, the local computer's regional settings are used as defaults values for omitted arguments.
  • All settings information comes from the Regional Settings Currency tab, except leading zero, which comes from the Number tab.

Requirement

2

Examples

Examples of FormatNumber function

ASP VbScript Command:
<script runat="server" language="VBScript">
Function cmda1:cmda1="FormatNumber(str,dad,ild,pnn,gbd)":cmda1=Left(cmda1,Len(cmda1)-4*(5-x)-1)&")":End Function
Dim vars,str,dad,ild,pnn,gbd,x,var:var=0
cmda=array("str","Eval(""cmda1"")","Eval(cmda1)")
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="str=Empty":x=1:dsp_x
vars="str=""0""":dsp_x
vars="str=""-1""":dsp_x
vars="str=""1""":dsp_x
vars="str=0":dsp_x
vars="str=-1":dsp_x
vars="str=1":dsp_x
vars="str=0.7545":dsp_x
vars="str=0.7545:dad=2.6":x=2:dsp_x
vars="str=0.7545:dad=2.5":dsp_x
vars="str=0.7545:dad=2.4":dsp_x
vars="str=0.7545:dad=2":dsp_x
vars="str=0.7545:dad=1.6":dsp_x
vars="str=0.7545:dad=1.5":dsp_x
vars="str=0.7545:dad=1.4":dsp_x
vars="str=0.7545:dad=0.6":dsp_x
vars="str=0.7545:dad=0.5":dsp_x
vars="str=0.7545:dad=0.4":dsp_x
vars="str=0.7545:dad=0":dsp_x
vars="str=0.7545:dad=-0.4":dsp_x
vars="str=0.7545:dad=-0.5":dsp_x
vars="str=0.7545:dad=-0.6":dsp_x
vars="str=0.7545:dad=-1":dsp_x
vars="str=0.7545:dad=-1.4":dsp_x
vars="str=0.7545:dad=-1":dsp_x
vars="str=0.7545:dad=0":dsp_x
vars="str=0.7545:dad=1":dsp_x
vars="str=0.7545:dad=2":dsp_x
vars="str=0.7545:dad=3":dsp_x
vars="str=0.7545:dad=4":dsp_x
vars="str=0.7545:dad=5":dsp_x
vars="str=-0.7545:dad=-1":dsp_x
vars="str=-0.7545:dad=0":dsp_x
vars="str=-0.7545:dad=1":dsp_x
vars="str=-0.7545:dad=2":dsp_x
vars="str=-0.7545:dad=3":dsp_x
vars="str=-0.7545:dad=4":dsp_x
vars="str=-0.7545:dad=5":dsp_x
vars="str=0.7545":x=1:dsp_x
vars="str=0.7545:dad=2":x=2:dsp_x
vars="str=0.7545:dad=4:ild=-2":x=3:dsp_x
vars="str=0.7545:dad=4:ild=-1":dsp_x
vars="str=0.7545:dad=4:ild=0":dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=-2":x=4:dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=-1":dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=0":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=-2":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=-1":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=0":dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=0:gbd=-2":x=5:dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=0:gbd=-1":dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=0:gbd=0":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=0:gbd=-2":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=0:gbd=-1":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=0:gbd=0":dsp_x
vars="str=-0.7545":x=1:dsp_x
vars="str=-0.7545:dad=2":x=2:dsp_x
vars="str=-0.7545:dad=4:ild=-2":x=3:dsp_x
vars="str=-0.7545:dad=4:ild=-1":dsp_x
vars="str=-0.7545:dad=4:ild=0":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=-2":x=4:dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=-1":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=0":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=-2":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=-1":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=0":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=-1:gbd=-2":x=5:dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=-1:gbd=-1":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=-1:gbd=0":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=-1:gbd=-2":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=-1:gbd=-1":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=-1:gbd=0":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=0:gbd=-2":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=0:gbd=-1":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=0:gbd=0":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=0:gbd=-2":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=0:gbd=-1":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=0:gbd=0":dsp_x
vars="str=1000000":x=1:dsp_x
vars="str=1000000:dad=2":x=2:dsp_x
vars="str=1000000:dad=4:ild=-2":x=3:dsp_x
vars="str=1000000:dad=4:ild=-1":dsp_x
vars="str=1000000:dad=4:ild=0":dsp_x
vars="str=1000000:dad=4:ild=0:pnn=-2":x=4:dsp_x
vars="str=1000000:dad=4:ild=0:pnn=-1":dsp_x
vars="str=1000000:dad=4:ild=0:pnn=0":dsp_x
vars="str=1000000:dad=4:ild=0:pnn=0:gbd=-2":x=5:dsp_x
vars="str=1000000:dad=4:ild=0:pnn=0:gbd=-1":dsp_x
vars="str=1000000:dad=4:ild=0:pnn=0:gbd=0":dsp_x
vars="str=-1000000":x=1:dsp_x
vars="str=-1000000:dad=2":x=2:dsp_x
vars="str=-1000000:dad=4:ild=-2":x=3:dsp_x
vars="str=-1000000:dad=4:ild=-1":dsp_x
vars="str=-1000000:dad=4:ild=0":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=-2":x=4:dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=-1":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=0":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=-1:gbd=-2":x=5:dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=-1:gbd=-1":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=-1:gbd=0":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=0:gbd=-2":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=0:gbd=-1":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=0:gbd=0":dsp_x
</script>
HTML Web Page In-line Output:
Results on Microsoft Windows 8.1 Pro x64, Microsoft-IIS/8.5, VBScript Version 5.8 of page /internet/users/sideblog/default.asp
varsstr, TypeNameEval("cmda1"), TypeNameEval(cmda1), TypeNamestr=Empty[], Empty[FormatNumber(str)], String[0.00], Stringstr="0"[0], String[FormatNumber(str)], String[0.00], Stringstr="-1"[-1], String[FormatNumber(str)], String[-1.00], Stringstr="1"[1], String[FormatNumber(str)], String[1.00], Stringstr=0[0], Integer[FormatNumber(str)], String[0.00], Stringstr=-1[-1], Integer[FormatNumber(str)], String[-1.00], Stringstr=1[1], Integer[FormatNumber(str)], String[1.00], Stringstr=0.7545[0.7545], Double[FormatNumber(str)], String[0.75], Stringstr=0.7545:dad=2.6[0.7545], Double[FormatNumber(str,dad)], String[0.755], Stringstr=0.7545:dad=2.5[0.7545], Double[FormatNumber(str,dad)], String[0.75], Stringstr=0.7545:dad=2.4[0.7545], Double[FormatNumber(str,dad)], String[0.75], Stringstr=0.7545:dad=2[0.7545], Double[FormatNumber(str,dad)], String[0.75], Stringstr=0.7545:dad=1.6[0.7545], Double[FormatNumber(str,dad)], String[0.75], Stringstr=0.7545:dad=1.5[0.7545], Double[FormatNumber(str,dad)], String[0.75], Stringstr=0.7545:dad=1.4[0.7545], Double[FormatNumber(str,dad)], String[0.8], Stringstr=0.7545:dad=0.6[0.7545], Double[FormatNumber(str,dad)], String[0.8], Stringstr=0.7545:dad=0.5[0.7545], Double[FormatNumber(str,dad)], String[1], Stringstr=0.7545:dad=0.4[0.7545], Double[FormatNumber(str,dad)], String[1], Stringstr=0.7545:dad=0[0.7545], Double[FormatNumber(str,dad)], String[1], Stringstr=0.7545:dad=-0.4[0.7545], Double[FormatNumber(str,dad)], String[1], Stringstr=0.7545:dad=-0.5[0.7545], Double[FormatNumber(str,dad)], String[1], Stringstr=0.7545:dad=-0.6[0.7545], Double[FormatNumber(str,dad)], String[0.75], Stringstr=0.7545:dad=-1[0.7545], Double[FormatNumber(str,dad)], String[0.75], Stringstr=0.7545:dad=-1.4[0.7545], Double[FormatNumber(str,dad)], String[0.75], Stringstr=0.7545:dad=-1[0.7545], Double[FormatNumber(str,dad)], String[0.75], Stringstr=0.7545:dad=0[0.7545], Double[FormatNumber(str,dad)], String[1], Stringstr=0.7545:dad=1[0.7545], Double[FormatNumber(str,dad)], String[0.8], Stringstr=0.7545:dad=2[0.7545], Double[FormatNumber(str,dad)], String[0.75], Stringstr=0.7545:dad=3[0.7545], Double[FormatNumber(str,dad)], String[0.755], Stringstr=0.7545:dad=4[0.7545], Double[FormatNumber(str,dad)], String[0.7545], Stringstr=0.7545:dad=5[0.7545], Double[FormatNumber(str,dad)], String[0.75450], Stringstr=-0.7545:dad=-1[-0.7545], Double[FormatNumber(str,dad)], String[-0.75], Stringstr=-0.7545:dad=0[-0.7545], Double[FormatNumber(str,dad)], String[-1], Stringstr=-0.7545:dad=1[-0.7545], Double[FormatNumber(str,dad)], String[-0.8], Stringstr=-0.7545:dad=2[-0.7545], Double[FormatNumber(str,dad)], String[-0.75], Stringstr=-0.7545:dad=3[-0.7545], Double[FormatNumber(str,dad)], String[-0.755], Stringstr=-0.7545:dad=4[-0.7545], Double[FormatNumber(str,dad)], String[-0.7545], Stringstr=-0.7545:dad=5[-0.7545], Double[FormatNumber(str,dad)], String[-0.75450], Stringstr=0.7545[0.7545], Double[FormatNumber(str)], String[0.75], Stringstr=0.7545:dad=2[0.7545], Double[FormatNumber(str,dad)], String[0.75], Stringstr=0.7545:dad=4:ild=-2[0.7545], Double[FormatNumber(str,dad,ild)], String[0.7545], Stringstr=0.7545:dad=4:ild=-1[0.7545], Double[FormatNumber(str,dad,ild)], String[0.7545], Stringstr=0.7545:dad=4:ild=0[0.7545], Double[FormatNumber(str,dad,ild)], String[.7545], Stringstr=0.7545:dad=4:ild=-1:pnn=-2[0.7545], Double[FormatNumber(str,dad,ild,pnn)], String[0.7545], Stringstr=0.7545:dad=4:ild=-1:pnn=-1[0.7545], Double[FormatNumber(str,dad,ild,pnn)], String[0.7545], Stringstr=0.7545:dad=4:ild=-1:pnn=0[0.7545], Double[FormatNumber(str,dad,ild,pnn)], String[0.7545], Stringstr=0.7545:dad=4:ild=0:pnn=-2[0.7545], Double[FormatNumber(str,dad,ild,pnn)], String[.7545], Stringstr=0.7545:dad=4:ild=0:pnn=-1[0.7545], Double[FormatNumber(str,dad,ild,pnn)], String[.7545], Stringstr=0.7545:dad=4:ild=0:pnn=0[0.7545], Double[FormatNumber(str,dad,ild,pnn)], String[.7545], Stringstr=0.7545:dad=4:ild=-1:pnn=0:gbd=-2[0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[0.7545], Stringstr=0.7545:dad=4:ild=-1:pnn=0:gbd=-1[0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[0.7545], Stringstr=0.7545:dad=4:ild=-1:pnn=0:gbd=0[0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[0.7545], Stringstr=0.7545:dad=4:ild=0:pnn=0:gbd=-2[0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[.7545], Stringstr=0.7545:dad=4:ild=0:pnn=0:gbd=-1[0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[.7545], Stringstr=0.7545:dad=4:ild=0:pnn=0:gbd=0[0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[.7545], Stringstr=-0.7545[-0.7545], Double[FormatNumber(str)], String[-0.75], Stringstr=-0.7545:dad=2[-0.7545], Double[FormatNumber(str,dad)], String[-0.75], Stringstr=-0.7545:dad=4:ild=-2[-0.7545], Double[FormatNumber(str,dad,ild)], String[-0.7545], Stringstr=-0.7545:dad=4:ild=-1[-0.7545], Double[FormatNumber(str,dad,ild)], String[-0.7545], Stringstr=-0.7545:dad=4:ild=0[-0.7545], Double[FormatNumber(str,dad,ild)], String[-.7545], Stringstr=-0.7545:dad=4:ild=-1:pnn=-2[-0.7545], Double[FormatNumber(str,dad,ild,pnn)], String[-0.7545], Stringstr=-0.7545:dad=4:ild=-1:pnn=-1[-0.7545], Double[FormatNumber(str,dad,ild,pnn)], String[(0.7545)], Stringstr=-0.7545:dad=4:ild=-1:pnn=0[-0.7545], Double[FormatNumber(str,dad,ild,pnn)], String[-0.7545], Stringstr=-0.7545:dad=4:ild=0:pnn=-2[-0.7545], Double[FormatNumber(str,dad,ild,pnn)], String[-.7545], Stringstr=-0.7545:dad=4:ild=0:pnn=-1[-0.7545], Double[FormatNumber(str,dad,ild,pnn)], String[(.7545)], Stringstr=-0.7545:dad=4:ild=0:pnn=0[-0.7545], Double[FormatNumber(str,dad,ild,pnn)], String[-.7545], Stringstr=-0.7545:dad=4:ild=-1:pnn=-1:gbd=-2[-0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[(0.7545)], Stringstr=-0.7545:dad=4:ild=-1:pnn=-1:gbd=-1[-0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[(0.7545)], Stringstr=-0.7545:dad=4:ild=-1:pnn=-1:gbd=0[-0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[(0.7545)], Stringstr=-0.7545:dad=4:ild=0:pnn=-1:gbd=-2[-0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[(.7545)], Stringstr=-0.7545:dad=4:ild=0:pnn=-1:gbd=-1[-0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[(.7545)], Stringstr=-0.7545:dad=4:ild=0:pnn=-1:gbd=0[-0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[(.7545)], Stringstr=-0.7545:dad=4:ild=-1:pnn=0:gbd=-2[-0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[-0.7545], Stringstr=-0.7545:dad=4:ild=-1:pnn=0:gbd=-1[-0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[-0.7545], Stringstr=-0.7545:dad=4:ild=-1:pnn=0:gbd=0[-0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[-0.7545], Stringstr=-0.7545:dad=4:ild=0:pnn=0:gbd=-2[-0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[-.7545], Stringstr=-0.7545:dad=4:ild=0:pnn=0:gbd=-1[-0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[-.7545], Stringstr=-0.7545:dad=4:ild=0:pnn=0:gbd=0[-0.7545], Double[FormatNumber(str,dad,ild,pnn,gbd)], String[-.7545], Stringstr=1000000[1000000], Long[FormatNumber(str)], String[1,000,000.00], Stringstr=1000000:dad=2[1000000], Long[FormatNumber(str,dad)], String[1,000,000.00], Stringstr=1000000:dad=4:ild=-2[1000000], Long[FormatNumber(str,dad,ild)], String[1,000,000.0000], Stringstr=1000000:dad=4:ild=-1[1000000], Long[FormatNumber(str,dad,ild)], String[1,000,000.0000], Stringstr=1000000:dad=4:ild=0[1000000], Long[FormatNumber(str,dad,ild)], String[1,000,000.0000], Stringstr=1000000:dad=4:ild=0:pnn=-2[1000000], Long[FormatNumber(str,dad,ild,pnn)], String[1,000,000.0000], Stringstr=1000000:dad=4:ild=0:pnn=-1[1000000], Long[FormatNumber(str,dad,ild,pnn)], String[1,000,000.0000], Stringstr=1000000:dad=4:ild=0:pnn=0[1000000], Long[FormatNumber(str,dad,ild,pnn)], String[1,000,000.0000], Stringstr=1000000:dad=4:ild=0:pnn=0:gbd=-2[1000000], Long[FormatNumber(str,dad,ild,pnn,gbd)], String[1,000,000.0000], Stringstr=1000000:dad=4:ild=0:pnn=0:gbd=-1[1000000], Long[FormatNumber(str,dad,ild,pnn,gbd)], String[1,000,000.0000], Stringstr=1000000:dad=4:ild=0:pnn=0:gbd=0[1000000], Long[FormatNumber(str,dad,ild,pnn,gbd)], String[1000000.0000], Stringstr=-1000000[-1000000], Long[FormatNumber(str)], String[-1,000,000.00], Stringstr=-1000000:dad=2[-1000000], Long[FormatNumber(str,dad)], String[-1,000,000.00], Stringstr=-1000000:dad=4:ild=-2[-1000000], Long[FormatNumber(str,dad,ild)], String[-1,000,000.0000], Stringstr=-1000000:dad=4:ild=-1[-1000000], Long[FormatNumber(str,dad,ild)], String[-1,000,000.0000], Stringstr=-1000000:dad=4:ild=0[-1000000], Long[FormatNumber(str,dad,ild)], String[-1,000,000.0000], Stringstr=-1000000:dad=4:ild=0:pnn=-2[-1000000], Long[FormatNumber(str,dad,ild,pnn)], String[-1,000,000.0000], Stringstr=-1000000:dad=4:ild=0:pnn=-1[-1000000], Long[FormatNumber(str,dad,ild,pnn)], String[(1,000,000.0000)], Stringstr=-1000000:dad=4:ild=0:pnn=0[-1000000], Long[FormatNumber(str,dad,ild,pnn)], String[-1,000,000.0000], Stringstr=-1000000:dad=4:ild=0:pnn=-1:gbd=-2[-1000000], Long[FormatNumber(str,dad,ild,pnn,gbd)], String[(1,000,000.0000)], Stringstr=-1000000:dad=4:ild=0:pnn=-1:gbd=-1[-1000000], Long[FormatNumber(str,dad,ild,pnn,gbd)], String[(1,000,000.0000)], Stringstr=-1000000:dad=4:ild=0:pnn=-1:gbd=0[-1000000], Long[FormatNumber(str,dad,ild,pnn,gbd)], String[(1000000.0000)], Stringstr=-1000000:dad=4:ild=0:pnn=0:gbd=-2[-1000000], Long[FormatNumber(str,dad,ild,pnn,gbd)], String[-1,000,000.0000], Stringstr=-1000000:dad=4:ild=0:pnn=0:gbd=-1[-1000000], Long[FormatNumber(str,dad,ild,pnn,gbd)], String[-1,000,000.0000], Stringstr=-1000000:dad=4:ild=0:pnn=0:gbd=0[-1000000], Long[FormatNumber(str,dad,ild,pnn,gbd)], String[-1000000.0000], String

FormatCurrency Function

last updated 9/18/2017

Create a string of a formatted currency value expression with a currency symbol defined in the local computer's regional settings from a given numeric or is evaluated as numeric expression according to local system settings and specified arguments.

Syntax

FormatCurrency(Expression [,NumDigitsAfterDecimal [,IncludeLeadingDigit
 [,UseParensForNegativeNumbers [,GroupDigits]]]])

Argument

ExpressionRequired. Expression to be formatted.NumDigitsAfterDecimalOptional. Numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the local computer's regional settings are used.IncludeLeadingDigitOptional setting. Tristate constant that indicates whether or not a leading zero is displayed for fractional values. UseParensForNegativeNumbersOptional setting. Tristate constant that indicates whether or not to place negative values within parentheses. GroupDigitsOptional setting. Tristate constant that indicates whether or not numbers are grouped using the group delimiter specified in the local computer's regional settings.

Settings

IncludeLeadingDigit, UseParensForNegativeNumbers, and GroupDigits arguments

vbConstantValueDescriptionvbUseDefault-2Use default from local computer's regional settings.vbTrue-1TruevbFalse0False

Returns

Returns a Variant of the String data subtype containing a string of a formatted currency value expression with a currency symbol defined in the local computer's regional settings from a given numeric or is evaluated as numeric expression according to local system settings and specified arguments.

Special returns of FormatCurrency function:

numberreturn valueNullRun-time ErrorEmptye.g. $0.00""Run-time Error

Remarks

  • The number value of NumDigitsAfterDecimal arguments can be any valid numeric expression greater than or equal to -1.4 and is equal to Round(NumDigitsAfterDecimal)
  • The rounding of the numeric value of Expression use theround to nearest method but following the round half away from zero rule, not the round half to even rule used in Round function.
  • When one or more optional arguments are omitted, the local computer's regional settings are used as defaults values for omitted arguments.
  • The currency symbol is defined in the local computer's regional settings
  • The position of the currency symbol relative to the currency value is determined by the local computer's regional settings.
  • All settings information comes from the Regional Settings Currency tab, except leading zero, which comes from the Number tab.

Requirement

2

Examples

Examples of FormatCurrency function

ASP VbScript Command:
<script runat="server" language="VBScript">
Function cmda1:cmda1="FormatCurrency(str,dad,ild,pnn,gbd)":cmda1=Left(cmda1,Len(cmda1)-4*(5-x)-1)&")":End Function
Dim vars,str,dad,ild,pnn,gbd,x,cmda,var:var=0
cmda=array("str","Eval(""cmda1"")","Eval(cmda1)")
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="str=Empty":x=1:dsp_x
vars="str=""0""":dsp_x
vars="str=""-1""":dsp_x
vars="str=""1""":dsp_x
vars="str=0":dsp_x
vars="str=-1":dsp_x
vars="str=1":dsp_x
vars="str=0.7545":dsp_x
vars="str=0.7545:dad=2.6":x=2:dsp_x
vars="str=0.7545:dad=2.5":dsp_x
vars="str=0.7545:dad=2.4":dsp_x
vars="str=0.7545:dad=2":dsp_x
vars="str=0.7545:dad=1.6":dsp_x
vars="str=0.7545:dad=1.5":dsp_x
vars="str=0.7545:dad=1.4":dsp_x
vars="str=0.7545:dad=0.6":dsp_x
vars="str=0.7545:dad=0.5":dsp_x
vars="str=0.7545:dad=0.4":dsp_x
vars="str=0.7545:dad=0":dsp_x
vars="str=0.7545:dad=-0.4":dsp_x
vars="str=0.7545:dad=-0.5":dsp_x
vars="str=0.7545:dad=-0.6":dsp_x
vars="str=0.7545:dad=-1":dsp_x
vars="str=0.7545:dad=-1.4":dsp_x
vars="str=0.7545:dad=-1":dsp_x
vars="str=0.7545:dad=0":dsp_x
vars="str=0.7545:dad=1":dsp_x
vars="str=0.7545:dad=2":dsp_x
vars="str=0.7545:dad=3":dsp_x
vars="str=0.7545:dad=4":dsp_x
vars="str=0.7545:dad=5":dsp_x
vars="str=-0.7545:dad=-1":dsp_x
vars="str=-0.7545:dad=0":dsp_x
vars="str=-0.7545:dad=1":dsp_x
vars="str=-0.7545:dad=2":dsp_x
vars="str=-0.7545:dad=3":dsp_x
vars="str=-0.7545:dad=4":dsp_x
vars="str=-0.7545:dad=5":dsp_x
vars="str=0.7545":x=1:dsp_x
vars="str=0.7545:dad=2":x=2:dsp_x
vars="str=0.7545:dad=4:ild=-2":x=3:dsp_x
vars="str=0.7545:dad=4:ild=-1":dsp_x
vars="str=0.7545:dad=4:ild=0":dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=-2":x=4:dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=-1":dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=0":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=-2":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=-1":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=0":dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=0:gbd=-2":x=5:dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=0:gbd=-1":dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=0:gbd=0":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=0:gbd=-2":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=0:gbd=-1":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=0:gbd=0":dsp_x
vars="str=-0.7545":x=1:dsp_x
vars="str=-0.7545:dad=2":x=2:dsp_x
vars="str=-0.7545:dad=4:ild=-2":x=3:dsp_x
vars="str=-0.7545:dad=4:ild=-1":dsp_x
vars="str=-0.7545:dad=4:ild=0":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=-2":x=4:dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=-1":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=0":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=-2":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=-1":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=0":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=-1:gbd=-2":x=5:dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=-1:gbd=-1":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=-1:gbd=0":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=-1:gbd=-2":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=-1:gbd=-1":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=-1:gbd=0":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=0:gbd=-2":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=0:gbd=-1":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=0:gbd=0":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=0:gbd=-2":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=0:gbd=-1":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=0:gbd=0":dsp_x
vars="str=1000000":x=1:dsp_x
vars="str=1000000:dad=2":x=2:dsp_x
vars="str=1000000:dad=4:ild=-2":x=3:dsp_x
vars="str=1000000:dad=4:ild=-1":dsp_x
vars="str=1000000:dad=4:ild=0":dsp_x
vars="str=1000000:dad=4:ild=0:pnn=-2":x=4:dsp_x
vars="str=1000000:dad=4:ild=0:pnn=-1":dsp_x
vars="str=1000000:dad=4:ild=0:pnn=0":dsp_x
vars="str=1000000:dad=4:ild=0:pnn=0:gbd=-2":x=5:dsp_x
vars="str=1000000:dad=4:ild=0:pnn=0:gbd=-1":dsp_x
vars="str=1000000:dad=4:ild=0:pnn=0:gbd=0":dsp_x
vars="str=-1000000":x=1:dsp_x
vars="str=-1000000:dad=2":x=2:dsp_x
vars="str=-1000000:dad=4:ild=-2":x=3:dsp_x
vars="str=-1000000:dad=4:ild=-1":dsp_x
vars="str=-1000000:dad=4:ild=0":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=-2":x=4:dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=-1":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=0":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=-1:gbd=-2":x=5:dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=-1:gbd=-1":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=-1:gbd=0":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=0:gbd=-2":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=0:gbd=-1":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=0:gbd=0":dsp_x
</script>
HTML Web Page In-line Output:
Results on Microsoft Windows 8.1 Pro x64, Microsoft-IIS/8.5, VBScript Version 5.8 of page /internet/users/sideblog/default.asp
varsstr, TypeNameEval("cmda1"), TypeNameEval(cmda1), TypeNamestr=Empty[], Empty[FormatCurrency(str)], String[$0.00], Stringstr="0"[0], String[FormatCurrency(str)], String[$0.00], Stringstr="-1"[-1], String[FormatCurrency(str)], String[($1.00)], Stringstr="1"[1], String[FormatCurrency(str)], String[$1.00], Stringstr=0[0], Integer[FormatCurrency(str)], String[$0.00], Stringstr=-1[-1], Integer[FormatCurrency(str)], String[($1.00)], Stringstr=1[1], Integer[FormatCurrency(str)], String[$1.00], Stringstr=0.7545[0.7545], Double[FormatCurrency(str)], String[$0.75], Stringstr=0.7545:dad=2.6[0.7545], Double[FormatCurrency(str,dad)], String[$0.755], Stringstr=0.7545:dad=2.5[0.7545], Double[FormatCurrency(str,dad)], String[$0.75], Stringstr=0.7545:dad=2.4[0.7545], Double[FormatCurrency(str,dad)], String[$0.75], Stringstr=0.7545:dad=2[0.7545], Double[FormatCurrency(str,dad)], String[$0.75], Stringstr=0.7545:dad=1.6[0.7545], Double[FormatCurrency(str,dad)], String[$0.75], Stringstr=0.7545:dad=1.5[0.7545], Double[FormatCurrency(str,dad)], String[$0.75], Stringstr=0.7545:dad=1.4[0.7545], Double[FormatCurrency(str,dad)], String[$0.8], Stringstr=0.7545:dad=0.6[0.7545], Double[FormatCurrency(str,dad)], String[$0.8], Stringstr=0.7545:dad=0.5[0.7545], Double[FormatCurrency(str,dad)], String[$1], Stringstr=0.7545:dad=0.4[0.7545], Double[FormatCurrency(str,dad)], String[$1], Stringstr=0.7545:dad=0[0.7545], Double[FormatCurrency(str,dad)], String[$1], Stringstr=0.7545:dad=-0.4[0.7545], Double[FormatCurrency(str,dad)], String[$1], Stringstr=0.7545:dad=-0.5[0.7545], Double[FormatCurrency(str,dad)], String[$1], Stringstr=0.7545:dad=-0.6[0.7545], Double[FormatCurrency(str,dad)], String[$0.75], Stringstr=0.7545:dad=-1[0.7545], Double[FormatCurrency(str,dad)], String[$0.75], Stringstr=0.7545:dad=-1.4[0.7545], Double[FormatCurrency(str,dad)], String[$0.75], Stringstr=0.7545:dad=-1[0.7545], Double[FormatCurrency(str,dad)], String[$0.75], Stringstr=0.7545:dad=0[0.7545], Double[FormatCurrency(str,dad)], String[$1], Stringstr=0.7545:dad=1[0.7545], Double[FormatCurrency(str,dad)], String[$0.8], Stringstr=0.7545:dad=2[0.7545], Double[FormatCurrency(str,dad)], String[$0.75], Stringstr=0.7545:dad=3[0.7545], Double[FormatCurrency(str,dad)], String[$0.755], Stringstr=0.7545:dad=4[0.7545], Double[FormatCurrency(str,dad)], String[$0.7545], Stringstr=0.7545:dad=5[0.7545], Double[FormatCurrency(str,dad)], String[$0.75450], Stringstr=-0.7545:dad=-1[-0.7545], Double[FormatCurrency(str,dad)], String[($0.75)], Stringstr=-0.7545:dad=0[-0.7545], Double[FormatCurrency(str,dad)], String[($1)], Stringstr=-0.7545:dad=1[-0.7545], Double[FormatCurrency(str,dad)], String[($0.8)], Stringstr=-0.7545:dad=2[-0.7545], Double[FormatCurrency(str,dad)], String[($0.75)], Stringstr=-0.7545:dad=3[-0.7545], Double[FormatCurrency(str,dad)], String[($0.755)], Stringstr=-0.7545:dad=4[-0.7545], Double[FormatCurrency(str,dad)], String[($0.7545)], Stringstr=-0.7545:dad=5[-0.7545], Double[FormatCurrency(str,dad)], String[($0.75450)], Stringstr=0.7545[0.7545], Double[FormatCurrency(str)], String[$0.75], Stringstr=0.7545:dad=2[0.7545], Double[FormatCurrency(str,dad)], String[$0.75], Stringstr=0.7545:dad=4:ild=-2[0.7545], Double[FormatCurrency(str,dad,ild)], String[$0.7545], Stringstr=0.7545:dad=4:ild=-1[0.7545], Double[FormatCurrency(str,dad,ild)], String[$0.7545], Stringstr=0.7545:dad=4:ild=0[0.7545], Double[FormatCurrency(str,dad,ild)], String[$.7545], Stringstr=0.7545:dad=4:ild=-1:pnn=-2[0.7545], Double[FormatCurrency(str,dad,ild,pnn)], String[$0.7545], Stringstr=0.7545:dad=4:ild=-1:pnn=-1[0.7545], Double[FormatCurrency(str,dad,ild,pnn)], String[$0.7545], Stringstr=0.7545:dad=4:ild=-1:pnn=0[0.7545], Double[FormatCurrency(str,dad,ild,pnn)], String[$0.7545], Stringstr=0.7545:dad=4:ild=0:pnn=-2[0.7545], Double[FormatCurrency(str,dad,ild,pnn)], String[$.7545], Stringstr=0.7545:dad=4:ild=0:pnn=-1[0.7545], Double[FormatCurrency(str,dad,ild,pnn)], String[$.7545], Stringstr=0.7545:dad=4:ild=0:pnn=0[0.7545], Double[FormatCurrency(str,dad,ild,pnn)], String[$.7545], Stringstr=0.7545:dad=4:ild=-1:pnn=0:gbd=-2[0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[$0.7545], Stringstr=0.7545:dad=4:ild=-1:pnn=0:gbd=-1[0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[$0.7545], Stringstr=0.7545:dad=4:ild=-1:pnn=0:gbd=0[0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[$0.7545], Stringstr=0.7545:dad=4:ild=0:pnn=0:gbd=-2[0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[$.7545], Stringstr=0.7545:dad=4:ild=0:pnn=0:gbd=-1[0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[$.7545], Stringstr=0.7545:dad=4:ild=0:pnn=0:gbd=0[0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[$.7545], Stringstr=-0.7545[-0.7545], Double[FormatCurrency(str)], String[($0.75)], Stringstr=-0.7545:dad=2[-0.7545], Double[FormatCurrency(str,dad)], String[($0.75)], Stringstr=-0.7545:dad=4:ild=-2[-0.7545], Double[FormatCurrency(str,dad,ild)], String[($0.7545)], Stringstr=-0.7545:dad=4:ild=-1[-0.7545], Double[FormatCurrency(str,dad,ild)], String[($0.7545)], Stringstr=-0.7545:dad=4:ild=0[-0.7545], Double[FormatCurrency(str,dad,ild)], String[($.7545)], Stringstr=-0.7545:dad=4:ild=-1:pnn=-2[-0.7545], Double[FormatCurrency(str,dad,ild,pnn)], String[($0.7545)], Stringstr=-0.7545:dad=4:ild=-1:pnn=-1[-0.7545], Double[FormatCurrency(str,dad,ild,pnn)], String[($0.7545)], Stringstr=-0.7545:dad=4:ild=-1:pnn=0[-0.7545], Double[FormatCurrency(str,dad,ild,pnn)], String[-$0.7545], Stringstr=-0.7545:dad=4:ild=0:pnn=-2[-0.7545], Double[FormatCurrency(str,dad,ild,pnn)], String[($.7545)], Stringstr=-0.7545:dad=4:ild=0:pnn=-1[-0.7545], Double[FormatCurrency(str,dad,ild,pnn)], String[($.7545)], Stringstr=-0.7545:dad=4:ild=0:pnn=0[-0.7545], Double[FormatCurrency(str,dad,ild,pnn)], String[-$.7545], Stringstr=-0.7545:dad=4:ild=-1:pnn=-1:gbd=-2[-0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[($0.7545)], Stringstr=-0.7545:dad=4:ild=-1:pnn=-1:gbd=-1[-0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[($0.7545)], Stringstr=-0.7545:dad=4:ild=-1:pnn=-1:gbd=0[-0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[($0.7545)], Stringstr=-0.7545:dad=4:ild=0:pnn=-1:gbd=-2[-0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[($.7545)], Stringstr=-0.7545:dad=4:ild=0:pnn=-1:gbd=-1[-0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[($.7545)], Stringstr=-0.7545:dad=4:ild=0:pnn=-1:gbd=0[-0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[($.7545)], Stringstr=-0.7545:dad=4:ild=-1:pnn=0:gbd=-2[-0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[-$0.7545], Stringstr=-0.7545:dad=4:ild=-1:pnn=0:gbd=-1[-0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[-$0.7545], Stringstr=-0.7545:dad=4:ild=-1:pnn=0:gbd=0[-0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[-$0.7545], Stringstr=-0.7545:dad=4:ild=0:pnn=0:gbd=-2[-0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[-$.7545], Stringstr=-0.7545:dad=4:ild=0:pnn=0:gbd=-1[-0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[-$.7545], Stringstr=-0.7545:dad=4:ild=0:pnn=0:gbd=0[-0.7545], Double[FormatCurrency(str,dad,ild,pnn,gbd)], String[-$.7545], Stringstr=1000000[1000000], Long[FormatCurrency(str)], String[$1,000,000.00], Stringstr=1000000:dad=2[1000000], Long[FormatCurrency(str,dad)], String[$1,000,000.00], Stringstr=1000000:dad=4:ild=-2[1000000], Long[FormatCurrency(str,dad,ild)], String[$1,000,000.0000], Stringstr=1000000:dad=4:ild=-1[1000000], Long[FormatCurrency(str,dad,ild)], String[$1,000,000.0000], Stringstr=1000000:dad=4:ild=0[1000000], Long[FormatCurrency(str,dad,ild)], String[$1,000,000.0000], Stringstr=1000000:dad=4:ild=0:pnn=-2[1000000], Long[FormatCurrency(str,dad,ild,pnn)], String[$1,000,000.0000], Stringstr=1000000:dad=4:ild=0:pnn=-1[1000000], Long[FormatCurrency(str,dad,ild,pnn)], String[$1,000,000.0000], Stringstr=1000000:dad=4:ild=0:pnn=0[1000000], Long[FormatCurrency(str,dad,ild,pnn)], String[$1,000,000.0000], Stringstr=1000000:dad=4:ild=0:pnn=0:gbd=-2[1000000], Long[FormatCurrency(str,dad,ild,pnn,gbd)], String[$1,000,000.0000], Stringstr=1000000:dad=4:ild=0:pnn=0:gbd=-1[1000000], Long[FormatCurrency(str,dad,ild,pnn,gbd)], String[$1,000,000.0000], Stringstr=1000000:dad=4:ild=0:pnn=0:gbd=0[1000000], Long[FormatCurrency(str,dad,ild,pnn,gbd)], String[$1000000.0000], Stringstr=-1000000[-1000000], Long[FormatCurrency(str)], String[($1,000,000.00)], Stringstr=-1000000:dad=2[-1000000], Long[FormatCurrency(str,dad)], String[($1,000,000.00)], Stringstr=-1000000:dad=4:ild=-2[-1000000], Long[FormatCurrency(str,dad,ild)], String[($1,000,000.0000)], Stringstr=-1000000:dad=4:ild=-1[-1000000], Long[FormatCurrency(str,dad,ild)], String[($1,000,000.0000)], Stringstr=-1000000:dad=4:ild=0[-1000000], Long[FormatCurrency(str,dad,ild)], String[($1,000,000.0000)], Stringstr=-1000000:dad=4:ild=0:pnn=-2[-1000000], Long[FormatCurrency(str,dad,ild,pnn)], String[($1,000,000.0000)], Stringstr=-1000000:dad=4:ild=0:pnn=-1[-1000000], Long[FormatCurrency(str,dad,ild,pnn)], String[($1,000,000.0000)], Stringstr=-1000000:dad=4:ild=0:pnn=0[-1000000], Long[FormatCurrency(str,dad,ild,pnn)], String[-$1,000,000.0000], Stringstr=-1000000:dad=4:ild=0:pnn=-1:gbd=-2[-1000000], Long[FormatCurrency(str,dad,ild,pnn,gbd)], String[($1,000,000.0000)], Stringstr=-1000000:dad=4:ild=0:pnn=-1:gbd=-1[-1000000], Long[FormatCurrency(str,dad,ild,pnn,gbd)], String[($1,000,000.0000)], Stringstr=-1000000:dad=4:ild=0:pnn=-1:gbd=0[-1000000], Long[FormatCurrency(str,dad,ild,pnn,gbd)], String[($1000000.0000)], Stringstr=-1000000:dad=4:ild=0:pnn=0:gbd=-2[-1000000], Long[FormatCurrency(str,dad,ild,pnn,gbd)], String[-$1,000,000.0000], Stringstr=-1000000:dad=4:ild=0:pnn=0:gbd=-1[-1000000], Long[FormatCurrency(str,dad,ild,pnn,gbd)], String[-$1,000,000.0000], Stringstr=-1000000:dad=4:ild=0:pnn=0:gbd=0[-1000000], Long[FormatCurrency(str,dad,ild,pnn,gbd)], String[-$1000000.0000], String

FormatPercent Function

last updated 9/19/2017

Create a string of a formatted percentage value expression from a given numeric or is evaluated as numeric expression by multiplying the numeric value with 100 and adding a trailing % character according to local system settings and specified arguments.

Syntax

FormatPercent(Expression [,NumDigitsAfterDecimal [,IncludeLeadingDigit
 [,UseParensForNegativeNumbers [,GroupDigits]]]])

Argument

ExpressionRequired. Expression to be formatted.NumDigitsAfterDecimalOptional. Numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the local computer's regional settings are used.IncludeLeadingDigitOptional setting. Tristate constant that indicates whether or not a leading zero is displayed for fractional values. UseParensForNegativeNumbersOptional setting. Tristate constant that indicates whether or not to place negative values within parentheses. GroupDigitsOptional setting. Tristate constant that indicates whether or not numbers are grouped using the group delimiter specified in the local computer's regional settings.

Settings

IncludeLeadingDigit, UseParensForNegativeNumbers, and GroupDigits arguments

vbConstantValueDescriptionvbUseDefault-2Use default from computer's regional settings.vbTrue-1TruevbFalse0False

Returns

Returns a Variant of the String data subtype containing a string of a formatted percentage value expression from a given numeric or is evaluated as numeric expression by multiplying the numeric value with 100 and adding a trailing % character according to local system settings and specified arguments.

Special returns of FormatPercent function:

numberreturn valueNullRun-time ErrorEmptye.g. 0.00%""Run-time Error

Remarks

  • The number value of NumDigitsAfterDecimal arguments can be any valid numeric expression greater than or equal to -1.4 and is equal to Round(NumDigitsAfterDecimal)
  • The rounding of the numeric value of Expression use theround to nearest method but following the round half away from zero rule, not the round half to even rule used in Round function.
  • When one or more optional arguments are omitted, the local computer's regional settings are used as defaults values for omitted arguments.
  • All settings information comes from the Regional Settings Currency tab, except leading zero, which comes from the Number tab.

Requirement

2

Examples

Examples of FormatPercent function

ASP VbScript Command:
<script runat="server" language="VBScript">
Function cmda1:cmda1="FormatPercent(str,dad,ild,pnn,gbd)":cmda1=Left(cmda1,Len(cmda1)-4*(5-x)-1)&")":End Function
Dim vars,str,dad,ild,pnn,gbd,x,cmda,var:var=0
cmda=array("str","Eval(""cmda1"")","Eval(cmda1)")
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="str=Empty":x=1:dsp_x
vars="str=""0""":dsp_x
vars="str=""-1""":dsp_x
vars="str=""1""":dsp_x
vars="str=0":dsp_x
vars="str=-1":dsp_x
vars="str=1":dsp_x
vars="str=0.7545":dsp_x
vars="str=0.7545:dad=2.6":x=2:dsp_x
vars="str=0.7545:dad=2.5":dsp_x
vars="str=0.7545:dad=2.4":dsp_x
vars="str=0.7545:dad=2":dsp_x
vars="str=0.7545:dad=1.6":dsp_x
vars="str=0.7545:dad=1.5":dsp_x
vars="str=0.7545:dad=1.4":dsp_x
vars="str=0.7545:dad=0.6":dsp_x
vars="str=0.7545:dad=0.5":dsp_x
vars="str=0.7545:dad=0.4":dsp_x
vars="str=0.7545:dad=0":dsp_x
vars="str=0.7545:dad=-0.4":dsp_x
vars="str=0.7545:dad=-0.5":dsp_x
vars="str=0.7545:dad=-0.6":dsp_x
vars="str=0.7545:dad=-1":dsp_x
vars="str=0.7545:dad=-1.4":dsp_x
vars="str=0.7545:dad=-1":dsp_x
vars="str=0.7545:dad=0":dsp_x
vars="str=0.7545:dad=1":dsp_x
vars="str=0.7545:dad=2":dsp_x
vars="str=0.7545:dad=3":dsp_x
vars="str=0.7545:dad=4":dsp_x
vars="str=0.7545:dad=5":dsp_x
vars="str=-0.7545:dad=-1":dsp_x
vars="str=-0.7545:dad=0":dsp_x
vars="str=-0.7545:dad=1":dsp_x
vars="str=-0.7545:dad=2":dsp_x
vars="str=-0.7545:dad=3":dsp_x
vars="str=-0.7545:dad=4":dsp_x
vars="str=-0.7545:dad=5":dsp_x
vars="str=0.7545":x=1:dsp_x
vars="str=0.7545:dad=2":x=2:dsp_x
vars="str=0.7545:dad=4:ild=-2":x=3:dsp_x
vars="str=0.7545:dad=4:ild=-1":dsp_x
vars="str=0.7545:dad=4:ild=0":dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=-2":x=4:dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=-1":dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=0":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=-2":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=-1":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=0":dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=0:gbd=-2":x=5:dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=0:gbd=-1":dsp_x
vars="str=0.7545:dad=4:ild=-1:pnn=0:gbd=0":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=0:gbd=-2":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=0:gbd=-1":dsp_x
vars="str=0.7545:dad=4:ild=0:pnn=0:gbd=0":dsp_x
vars="str=-0.7545":x=1:dsp_x
vars="str=-0.7545:dad=2":x=2:dsp_x
vars="str=-0.7545:dad=4:ild=-2":x=3:dsp_x
vars="str=-0.7545:dad=4:ild=-1":dsp_x
vars="str=-0.7545:dad=4:ild=0":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=-2":x=4:dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=-1":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=0":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=-2":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=-1":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=0":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=-1:gbd=-2":x=5:dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=-1:gbd=-1":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=-1:gbd=0":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=-1:gbd=-2":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=-1:gbd=-1":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=-1:gbd=0":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=0:gbd=-2":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=0:gbd=-1":dsp_x
vars="str=-0.7545:dad=4:ild=-1:pnn=0:gbd=0":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=0:gbd=-2":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=0:gbd=-1":dsp_x
vars="str=-0.7545:dad=4:ild=0:pnn=0:gbd=0":dsp_x
vars="str=1000000":x=1:dsp_x
vars="str=1000000:dad=2":x=2:dsp_x
vars="str=1000000:dad=4:ild=-2":x=3:dsp_x
vars="str=1000000:dad=4:ild=-1":dsp_x
vars="str=1000000:dad=4:ild=0":dsp_x
vars="str=1000000:dad=4:ild=0:pnn=-2":x=4:dsp_x
vars="str=1000000:dad=4:ild=0:pnn=-1":dsp_x
vars="str=1000000:dad=4:ild=0:pnn=0":dsp_x
vars="str=1000000:dad=4:ild=0:pnn=0:gbd=-2":x=5:dsp_x
vars="str=1000000:dad=4:ild=0:pnn=0:gbd=-1":dsp_x
vars="str=1000000:dad=4:ild=0:pnn=0:gbd=0":dsp_x
vars="str=-1000000":x=1:dsp_x
vars="str=-1000000:dad=2":x=2:dsp_x
vars="str=-1000000:dad=4:ild=-2":x=3:dsp_x
vars="str=-1000000:dad=4:ild=-1":dsp_x
vars="str=-1000000:dad=4:ild=0":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=-2":x=4:dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=-1":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=0":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=-1:gbd=-2":x=5:dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=-1:gbd=-1":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=-1:gbd=0":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=0:gbd=-2":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=0:gbd=-1":dsp_x
vars="str=-1000000:dad=4:ild=0:pnn=0:gbd=0":dsp_x
</script>
HTML Web Page In-line Output:
Results on Microsoft Windows 8.1 Pro x64, Microsoft-IIS/8.5, VBScript Version 5.8 of page /internet/users/sideblog/default.asp
varsstr, TypeNameEval("cmda1"), TypeNameEval(cmda1), TypeNamestr=Empty[], Empty[FormatPercent(str)], String[0.00%], Stringstr="0"[0], String[FormatPercent(str)], String[0.00%], Stringstr="-1"[-1], String[FormatPercent(str)], String[-100.00%], Stringstr="1"[1], String[FormatPercent(str)], String[100.00%], Stringstr=0[0], Integer[FormatPercent(str)], String[0.00%], Stringstr=-1[-1], Integer[FormatPercent(str)], String[-100.00%], Stringstr=1[1], Integer[FormatPercent(str)], String[100.00%], Stringstr=0.7545[0.7545], Double[FormatPercent(str)], String[75.45%], Stringstr=0.7545:dad=2.6[0.7545], Double[FormatPercent(str,dad)], String[75.450%], Stringstr=0.7545:dad=2.5[0.7545], Double[FormatPercent(str,dad)], String[75.45%], Stringstr=0.7545:dad=2.4[0.7545], Double[FormatPercent(str,dad)], String[75.45%], Stringstr=0.7545:dad=2[0.7545], Double[FormatPercent(str,dad)], String[75.45%], Stringstr=0.7545:dad=1.6[0.7545], Double[FormatPercent(str,dad)], String[75.45%], Stringstr=0.7545:dad=1.5[0.7545], Double[FormatPercent(str,dad)], String[75.45%], Stringstr=0.7545:dad=1.4[0.7545], Double[FormatPercent(str,dad)], String[75.5%], Stringstr=0.7545:dad=0.6[0.7545], Double[FormatPercent(str,dad)], String[75.5%], Stringstr=0.7545:dad=0.5[0.7545], Double[FormatPercent(str,dad)], String[75%], Stringstr=0.7545:dad=0.4[0.7545], Double[FormatPercent(str,dad)], String[75%], Stringstr=0.7545:dad=0[0.7545], Double[FormatPercent(str,dad)], String[75%], Stringstr=0.7545:dad=-0.4[0.7545], Double[FormatPercent(str,dad)], String[75%], Stringstr=0.7545:dad=-0.5[0.7545], Double[FormatPercent(str,dad)], String[75%], Stringstr=0.7545:dad=-0.6[0.7545], Double[FormatPercent(str,dad)], String[75.45%], Stringstr=0.7545:dad=-1[0.7545], Double[FormatPercent(str,dad)], String[75.45%], Stringstr=0.7545:dad=-1.4[0.7545], Double[FormatPercent(str,dad)], String[75.45%], Stringstr=0.7545:dad=-1[0.7545], Double[FormatPercent(str,dad)], String[75.45%], Stringstr=0.7545:dad=0[0.7545], Double[FormatPercent(str,dad)], String[75%], Stringstr=0.7545:dad=1[0.7545], Double[FormatPercent(str,dad)], String[75.5%], Stringstr=0.7545:dad=2[0.7545], Double[FormatPercent(str,dad)], String[75.45%], Stringstr=0.7545:dad=3[0.7545], Double[FormatPercent(str,dad)], String[75.450%], Stringstr=0.7545:dad=4[0.7545], Double[FormatPercent(str,dad)], String[75.4500%], Stringstr=0.7545:dad=5[0.7545], Double[FormatPercent(str,dad)], String[75.45000%], Stringstr=-0.7545:dad=-1[-0.7545], Double[FormatPercent(str,dad)], String[-75.45%], Stringstr=-0.7545:dad=0[-0.7545], Double[FormatPercent(str,dad)], String[-75%], Stringstr=-0.7545:dad=1[-0.7545], Double[FormatPercent(str,dad)], String[-75.5%], Stringstr=-0.7545:dad=2[-0.7545], Double[FormatPercent(str,dad)], String[-75.45%], Stringstr=-0.7545:dad=3[-0.7545], Double[FormatPercent(str,dad)], String[-75.450%], Stringstr=-0.7545:dad=4[-0.7545], Double[FormatPercent(str,dad)], String[-75.4500%], Stringstr=-0.7545:dad=5[-0.7545], Double[FormatPercent(str,dad)], String[-75.45000%], Stringstr=0.7545[0.7545], Double[FormatPercent(str)], String[75.45%], Stringstr=0.7545:dad=2[0.7545], Double[FormatPercent(str,dad)], String[75.45%], Stringstr=0.7545:dad=4:ild=-2[0.7545], Double[FormatPercent(str,dad,ild)], String[75.4500%], Stringstr=0.7545:dad=4:ild=-1[0.7545], Double[FormatPercent(str,dad,ild)], String[75.4500%], Stringstr=0.7545:dad=4:ild=0[0.7545], Double[FormatPercent(str,dad,ild)], String[75.4500%], Stringstr=0.7545:dad=4:ild=-1:pnn=-2[0.7545], Double[FormatPercent(str,dad,ild,pnn)], String[75.4500%], Stringstr=0.7545:dad=4:ild=-1:pnn=-1[0.7545], Double[FormatPercent(str,dad,ild,pnn)], String[75.4500%], Stringstr=0.7545:dad=4:ild=-1:pnn=0[0.7545], Double[FormatPercent(str,dad,ild,pnn)], String[75.4500%], Stringstr=0.7545:dad=4:ild=0:pnn=-2[0.7545], Double[FormatPercent(str,dad,ild,pnn)], String[75.4500%], Stringstr=0.7545:dad=4:ild=0:pnn=-1[0.7545], Double[FormatPercent(str,dad,ild,pnn)], String[75.4500%], Stringstr=0.7545:dad=4:ild=0:pnn=0[0.7545], Double[FormatPercent(str,dad,ild,pnn)], String[75.4500%], Stringstr=0.7545:dad=4:ild=-1:pnn=0:gbd=-2[0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[75.4500%], Stringstr=0.7545:dad=4:ild=-1:pnn=0:gbd=-1[0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[75.4500%], Stringstr=0.7545:dad=4:ild=-1:pnn=0:gbd=0[0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[75.4500%], Stringstr=0.7545:dad=4:ild=0:pnn=0:gbd=-2[0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[75.4500%], Stringstr=0.7545:dad=4:ild=0:pnn=0:gbd=-1[0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[75.4500%], Stringstr=0.7545:dad=4:ild=0:pnn=0:gbd=0[0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[75.4500%], Stringstr=-0.7545[-0.7545], Double[FormatPercent(str)], String[-75.45%], Stringstr=-0.7545:dad=2[-0.7545], Double[FormatPercent(str,dad)], String[-75.45%], Stringstr=-0.7545:dad=4:ild=-2[-0.7545], Double[FormatPercent(str,dad,ild)], String[-75.4500%], Stringstr=-0.7545:dad=4:ild=-1[-0.7545], Double[FormatPercent(str,dad,ild)], String[-75.4500%], Stringstr=-0.7545:dad=4:ild=0[-0.7545], Double[FormatPercent(str,dad,ild)], String[-75.4500%], Stringstr=-0.7545:dad=4:ild=-1:pnn=-2[-0.7545], Double[FormatPercent(str,dad,ild,pnn)], String[-75.4500%], Stringstr=-0.7545:dad=4:ild=-1:pnn=-1[-0.7545], Double[FormatPercent(str,dad,ild,pnn)], String[(75.4500%)], Stringstr=-0.7545:dad=4:ild=-1:pnn=0[-0.7545], Double[FormatPercent(str,dad,ild,pnn)], String[-75.4500%], Stringstr=-0.7545:dad=4:ild=0:pnn=-2[-0.7545], Double[FormatPercent(str,dad,ild,pnn)], String[-75.4500%], Stringstr=-0.7545:dad=4:ild=0:pnn=-1[-0.7545], Double[FormatPercent(str,dad,ild,pnn)], String[(75.4500%)], Stringstr=-0.7545:dad=4:ild=0:pnn=0[-0.7545], Double[FormatPercent(str,dad,ild,pnn)], String[-75.4500%], Stringstr=-0.7545:dad=4:ild=-1:pnn=-1:gbd=-2[-0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[(75.4500%)], Stringstr=-0.7545:dad=4:ild=-1:pnn=-1:gbd=-1[-0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[(75.4500%)], Stringstr=-0.7545:dad=4:ild=-1:pnn=-1:gbd=0[-0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[(75.4500%)], Stringstr=-0.7545:dad=4:ild=0:pnn=-1:gbd=-2[-0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[(75.4500%)], Stringstr=-0.7545:dad=4:ild=0:pnn=-1:gbd=-1[-0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[(75.4500%)], Stringstr=-0.7545:dad=4:ild=0:pnn=-1:gbd=0[-0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[(75.4500%)], Stringstr=-0.7545:dad=4:ild=-1:pnn=0:gbd=-2[-0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[-75.4500%], Stringstr=-0.7545:dad=4:ild=-1:pnn=0:gbd=-1[-0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[-75.4500%], Stringstr=-0.7545:dad=4:ild=-1:pnn=0:gbd=0[-0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[-75.4500%], Stringstr=-0.7545:dad=4:ild=0:pnn=0:gbd=-2[-0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[-75.4500%], Stringstr=-0.7545:dad=4:ild=0:pnn=0:gbd=-1[-0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[-75.4500%], Stringstr=-0.7545:dad=4:ild=0:pnn=0:gbd=0[-0.7545], Double[FormatPercent(str,dad,ild,pnn,gbd)], String[-75.4500%], Stringstr=1000000[1000000], Long[FormatPercent(str)], String[100,000,000.00%], Stringstr=1000000:dad=2[1000000], Long[FormatPercent(str,dad)], String[100,000,000.00%], Stringstr=1000000:dad=4:ild=-2[1000000], Long[FormatPercent(str,dad,ild)], String[100,000,000.0000%], Stringstr=1000000:dad=4:ild=-1[1000000], Long[FormatPercent(str,dad,ild)], String[100,000,000.0000%], Stringstr=1000000:dad=4:ild=0[1000000], Long[FormatPercent(str,dad,ild)], String[100,000,000.0000%], Stringstr=1000000:dad=4:ild=0:pnn=-2[1000000], Long[FormatPercent(str,dad,ild,pnn)], String[100,000,000.0000%], Stringstr=1000000:dad=4:ild=0:pnn=-1[1000000], Long[FormatPercent(str,dad,ild,pnn)], String[100,000,000.0000%], Stringstr=1000000:dad=4:ild=0:pnn=0[1000000], Long[FormatPercent(str,dad,ild,pnn)], String[100,000,000.0000%], Stringstr=1000000:dad=4:ild=0:pnn=0:gbd=-2[1000000], Long[FormatPercent(str,dad,ild,pnn,gbd)], String[100,000,000.0000%], Stringstr=1000000:dad=4:ild=0:pnn=0:gbd=-1[1000000], Long[FormatPercent(str,dad,ild,pnn,gbd)], String[100,000,000.0000%], Stringstr=1000000:dad=4:ild=0:pnn=0:gbd=0[1000000], Long[FormatPercent(str,dad,ild,pnn,gbd)], String[100000000.0000%], Stringstr=-1000000[-1000000], Long[FormatPercent(str)], String[-100,000,000.00%], Stringstr=-1000000:dad=2[-1000000], Long[FormatPercent(str,dad)], String[-100,000,000.00%], Stringstr=-1000000:dad=4:ild=-2[-1000000], Long[FormatPercent(str,dad,ild)], String[-100,000,000.0000%], Stringstr=-1000000:dad=4:ild=-1[-1000000], Long[FormatPercent(str,dad,ild)], String[-100,000,000.0000%], Stringstr=-1000000:dad=4:ild=0[-1000000], Long[FormatPercent(str,dad,ild)], String[-100,000,000.0000%], Stringstr=-1000000:dad=4:ild=0:pnn=-2[-1000000], Long[FormatPercent(str,dad,ild,pnn)], String[-100,000,000.0000%], Stringstr=-1000000:dad=4:ild=0:pnn=-1[-1000000], Long[FormatPercent(str,dad,ild,pnn)], String[(100,000,000.0000%)], Stringstr=-1000000:dad=4:ild=0:pnn=0[-1000000], Long[FormatPercent(str,dad,ild,pnn)], String[-100,000,000.0000%], Stringstr=-1000000:dad=4:ild=0:pnn=-1:gbd=-2[-1000000], Long[FormatPercent(str,dad,ild,pnn,gbd)], String[(100,000,000.0000%)], Stringstr=-1000000:dad=4:ild=0:pnn=-1:gbd=-1[-1000000], Long[FormatPercent(str,dad,ild,pnn,gbd)], String[(100,000,000.0000%)], Stringstr=-1000000:dad=4:ild=0:pnn=-1:gbd=0[-1000000], Long[FormatPercent(str,dad,ild,pnn,gbd)], String[(100000000.0000%)], Stringstr=-1000000:dad=4:ild=0:pnn=0:gbd=-2[-1000000], Long[FormatPercent(str,dad,ild,pnn,gbd)], String[-100,000,000.0000%], Stringstr=-1000000:dad=4:ild=0:pnn=0:gbd=-1[-1000000], Long[FormatPercent(str,dad,ild,pnn,gbd)], String[-100,000,000.0000%], Stringstr=-1000000:dad=4:ild=0:pnn=0:gbd=0[-1000000], Long[FormatPercent(str,dad,ild,pnn,gbd)], String[-100000000.0000%], String

FormatDateTime Function

last updated 9/18/2017

Create a string of a formatted date or time value expression from a given date or is evaluated as date expression according to local system settings and specified arguments.

Syntax

FormatDateTime(Date[, NamedFormat])

Argument

DateRequired. Any valid date/time expression that is to be formatted as a formatted date/time value expression.NamedFormatOptional setting. Numeric value that indicates the date/time format used. If omitted, vbGeneralDate is used.

Settings

NamedFormat argument

vbConstantValueDescriptionvbGeneralDate0 display the available date and time part of the Date expression. If present, a short date format is used to display the date part and a long time format is used to display the time part.vbLongDate1display only the date part of the Date expression and the long date format specified in local computer's regional settings is used.vbShortDate2display only the date part and the short date format specified in local computer's regional settings is used.vbLongTime3display only the time part of the Date expression and the time format specified in your computer's regional settings is used.vbShortTime4display only the time part of the Date expression and the 24-hour format (hh:mm) is used.

Returns

Returns a Variant of the String data subtype containing a string of a formatted date or time value expression from a given date or is evaluated as date expression according to local system settings and specified arguments.

Special returns of FormatDateTime function:

numberreturn valueNullRun-time ErrorEmptye.g 12:00:00 AM"Run-time Error

Remarks

  • FormatDateTime function always return a valid formatted date or time expression.

Requirement

2

Examples

Examples of FormatDateTime function

ASP VbScript Command:
<script runat="server" language="VBScript">
Function cmda1:cmda1="FormatDateTime(str,dfm)":cmda1=Left(cmda1,Len(cmda1)-4*(2-x)-1)&")":End Function
Dim vars,str,dfm,x,cmda,var:var=0
cmda=array("str","Eval(""cmda1"")","Eval(cmda1)")
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="str=Empty":x=1:dsp_x
vars="str=Empty:dfm=0":x=2:dsp_x
vars="str=Empty:dfm=1":dsp_x
vars="str=Empty:dfm=2":dsp_x
vars="str=Empty:dfm=3":dsp_x
vars="str=Empty:dfm=4":dsp_x
vars="str=#27 Mar 2010 9:38:53 PM#":x=1:dsp_x
vars="str=#27 Mar 2010 9:38:53 PM#:dfm=0":x=2:dsp_x
vars="str=#27 Mar 2010 9:38:53 PM#:dfm=1":dsp_x
vars="str=#27 Mar 2010 9:38:53 PM#:dfm=2":dsp_x
vars="str=#27 Mar 2010 9:38:53 PM#:dfm=3":dsp_x
vars="str=#27 Mar 2010 9:38:53 PM#:dfm=4":dsp_x
vars="str=""27 Mar 2010 9:38:53 PM""":x=1:dsp_x
vars="str=""27 Mar 2010 9:38:53 PM"":dfm=0":x=2:dsp_x
vars="str=""27 Mar 2010 9:38:53 PM"":dfm=1":dsp_x
vars="str=""27 Mar 2010 9:38:53 PM"":dfm=2":dsp_x
vars="str=""27 Mar 2010 9:38:53 PM"":dfm=3":dsp_x
vars="str=""27 Mar 2010 9:38:53 PM"":dfm=4":dsp_x
vars="str=#27 Mar 2010#":x=1:dsp_x
vars="str=#27 Mar 2010#:dfm=0":x=2:dsp_x
vars="str=#27 Mar 2010#:dfm=1":dsp_x
vars="str=#27 Mar 2010#:dfm=2":dsp_x
vars="str=#27 Mar 2010#:dfm=3":dsp_x
vars="str=#27 Mar 2010#:dfm=4":dsp_x
vars="str=""27 Mar 2010""":x=1:dsp_x
vars="str=""27 Mar 2010"":dfm=0":x=2:dsp_x
vars="str=""27 Mar 2010"":dfm=1":dsp_x
vars="str=""27 Mar 2010"":dfm=2":dsp_x
vars="str=""27 Mar 2010"":dfm=3":dsp_x
vars="str=""27 Mar 2010"":dfm=4":dsp_x
vars="str=#9:38:53 PM#":x=1:dsp_x
vars="str=#9:38:53 PM#:dfm=0":x=2:dsp_x
vars="str=#9:38:53 PM#:dfm=1":dsp_x
vars="str=#9:38:53 PM#:dfm=2":dsp_x
vars="str=#9:38:53 PM#:dfm=3":dsp_x
vars="str=#9:38:53 PM#:dfm=4":dsp_x
vars="str=""9:38:53 PM""":x=1:dsp_x
vars="str=""9:38:53 PM"":dfm=0":x=2:dsp_x
vars="str=""9:38:53 PM"":dfm=1":dsp_x
vars="str=""9:38:53 PM"":dfm=2":dsp_x
vars="str=""9:38:53 PM"":dfm=3":dsp_x
vars="str=""9:38:53 PM"":dfm=4":dsp_x
vars="str=""0""":x=1:dsp_x
vars="str=""0"":dfm=0":x=2:dsp_x
vars="str=""0"":dfm=1":dsp_x
vars="str=""0"":dfm=2":dsp_x
vars="str=""0"":dfm=3":dsp_x
vars="str=""0"":dfm=4":dsp_x
vars="str=""-1""":x=1:dsp_x
vars="str=""-1"":dfm=0":x=2:dsp_x
vars="str=""-1"":dfm=1":dsp_x
vars="str=""-1"":dfm=2":dsp_x
vars="str=""-1"":dfm=3":dsp_x
vars="str=""-1"":dfm=4":dsp_x
vars="str=""1""":x=1:dsp_x
vars="str=""1"":dfm=0":x=2:dsp_x
vars="str=""1"":dfm=1":dsp_x
vars="str=""1"":dfm=2":dsp_x
vars="str=""1"":dfm=3":dsp_x
vars="str=""1"":dfm=4":dsp_x
vars="str=0":x=1:dsp_x
vars="str=0:dfm=0":x=2:dsp_x
vars="str=0:dfm=1":dsp_x
vars="str=0:dfm=2":dsp_x
vars="str=0:dfm=3":dsp_x
vars="str=0:dfm=4":dsp_x
vars="str=-1":x=1:dsp_x
vars="str=-1:dfm=0":x=2:dsp_x
vars="str=-1:dfm=1":dsp_x
vars="str=-1:dfm=2":dsp_x
vars="str=-1:dfm=3":dsp_x
vars="str=-1:dfm=4":dsp_x
vars="str=1":x=1:dsp_x
vars="str=1:dfm=0":x=2:dsp_x
vars="str=1:dfm=1":dsp_x
vars="str=1:dfm=2":dsp_x
vars="str=1:dfm=3":dsp_x
vars="str=1:dfm=4":dsp_x
</script>
HTML Web Page In-line Output:
Results on Microsoft Windows 8.1 Pro x64, Microsoft-IIS/8.5, VBScript Version 5.8 of page /internet/users/sideblog/default.asp
varsstr, TypeNameEval("cmda1"), TypeNameEval(cmda1), TypeNamestr=Empty[], Empty[FormatDateTime(str)], String[12:00:00 AM], Stringstr=Empty:dfm=0[], Empty[FormatDateTime(str,dfm)], String[12:00:00 AM], Stringstr=Empty:dfm=1[], Empty[FormatDateTime(str,dfm)], String[Saturday, December 30, 1899], Stringstr=Empty:dfm=2[], Empty[FormatDateTime(str,dfm)], String[12/30/1899], Stringstr=Empty:dfm=3[], Empty[FormatDateTime(str,dfm)], String[12:00:00 AM], Stringstr=Empty:dfm=4[], Empty[FormatDateTime(str,dfm)], String[00:00], Stringstr=#27 Mar 2010 9:38:53 PM#[3/27/2010 9:38:53 PM], Date[FormatDateTime(str)], String[3/27/2010 9:38:53 PM], Stringstr=#27 Mar 2010 9:38:53 PM#:dfm=0[3/27/2010 9:38:53 PM], Date[FormatDateTime(str,dfm)], String[3/27/2010 9:38:53 PM], Stringstr=#27 Mar 2010 9:38:53 PM#:dfm=1[3/27/2010 9:38:53 PM], Date[FormatDateTime(str,dfm)], String[Saturday, March 27, 2010], Stringstr=#27 Mar 2010 9:38:53 PM#:dfm=2[3/27/2010 9:38:53 PM], Date[FormatDateTime(str,dfm)], String[3/27/2010], Stringstr=#27 Mar 2010 9:38:53 PM#:dfm=3[3/27/2010 9:38:53 PM], Date[FormatDateTime(str,dfm)], String[9:38:53 PM], Stringstr=#27 Mar 2010 9:38:53 PM#:dfm=4[3/27/2010 9:38:53 PM], Date[FormatDateTime(str,dfm)], String[21:38], Stringstr="27 Mar 2010 9:38:53 PM"[27 Mar 2010 9:38:53 PM], String[FormatDateTime(str)], String[3/27/2010 9:38:53 PM], Stringstr="27 Mar 2010 9:38:53 PM":dfm=0[27 Mar 2010 9:38:53 PM], String[FormatDateTime(str,dfm)], String[3/27/2010 9:38:53 PM], Stringstr="27 Mar 2010 9:38:53 PM":dfm=1[27 Mar 2010 9:38:53 PM], String[FormatDateTime(str,dfm)], String[Saturday, March 27, 2010], Stringstr="27 Mar 2010 9:38:53 PM":dfm=2[27 Mar 2010 9:38:53 PM], String[FormatDateTime(str,dfm)], String[3/27/2010], Stringstr="27 Mar 2010 9:38:53 PM":dfm=3[27 Mar 2010 9:38:53 PM], String[FormatDateTime(str,dfm)], String[9:38:53 PM], Stringstr="27 Mar 2010 9:38:53 PM":dfm=4[27 Mar 2010 9:38:53 PM], String[FormatDateTime(str,dfm)], String[21:38], Stringstr=#27 Mar 2010#[3/27/2010], Date[FormatDateTime(str)], String[3/27/2010], Stringstr=#27 Mar 2010#:dfm=0[3/27/2010], Date[FormatDateTime(str,dfm)], String[3/27/2010], Stringstr=#27 Mar 2010#:dfm=1[3/27/2010], Date[FormatDateTime(str,dfm)], String[Saturday, March 27, 2010], Stringstr=#27 Mar 2010#:dfm=2[3/27/2010], Date[FormatDateTime(str,dfm)], String[3/27/2010], Stringstr=#27 Mar 2010#:dfm=3[3/27/2010], Date[FormatDateTime(str,dfm)], String[12:00:00 AM], Stringstr=#27 Mar 2010#:dfm=4[3/27/2010], Date[FormatDateTime(str,dfm)], String[00:00], Stringstr="27 Mar 2010"[27 Mar 2010], String[FormatDateTime(str)], String[3/27/2010], Stringstr="27 Mar 2010":dfm=0[27 Mar 2010], String[FormatDateTime(str,dfm)], String[3/27/2010], Stringstr="27 Mar 2010":dfm=1[27 Mar 2010], String[FormatDateTime(str,dfm)], String[Saturday, March 27, 2010], Stringstr="27 Mar 2010":dfm=2[27 Mar 2010], String[FormatDateTime(str,dfm)], String[3/27/2010], Stringstr="27 Mar 2010":dfm=3[27 Mar 2010], String[FormatDateTime(str,dfm)], String[12:00:00 AM], Stringstr="27 Mar 2010":dfm=4[27 Mar 2010], String[FormatDateTime(str,dfm)], String[00:00], Stringstr=#9:38:53 PM#[9:38:53 PM], Date[FormatDateTime(str)], String[9:38:53 PM], Stringstr=#9:38:53 PM#:dfm=0[9:38:53 PM], Date[FormatDateTime(str,dfm)], String[9:38:53 PM], Stringstr=#9:38:53 PM#:dfm=1[9:38:53 PM], Date[FormatDateTime(str,dfm)], String[Saturday, December 30, 1899], Stringstr=#9:38:53 PM#:dfm=2[9:38:53 PM], Date[FormatDateTime(str,dfm)], String[12/30/1899], Stringstr=#9:38:53 PM#:dfm=3[9:38:53 PM], Date[FormatDateTime(str,dfm)], String[9:38:53 PM], Stringstr=#9:38:53 PM#:dfm=4[9:38:53 PM], Date[FormatDateTime(str,dfm)], String[21:38], Stringstr="9:38:53 PM"[9:38:53 PM], String[FormatDateTime(str)], String[9:38:53 PM], Stringstr="9:38:53 PM":dfm=0[9:38:53 PM], String[FormatDateTime(str,dfm)], String[9:38:53 PM], Stringstr="9:38:53 PM":dfm=1[9:38:53 PM], String[FormatDateTime(str,dfm)], String[Saturday, December 30, 1899], Stringstr="9:38:53 PM":dfm=2[9:38:53 PM], String[FormatDateTime(str,dfm)], String[12/30/1899], Stringstr="9:38:53 PM":dfm=3[9:38:53 PM], String[FormatDateTime(str,dfm)], String[9:38:53 PM], Stringstr="9:38:53 PM":dfm=4[9:38:53 PM], String[FormatDateTime(str,dfm)], String[21:38], Stringstr="0"[0], String[FormatDateTime(str)], String[12:00:00 AM], Stringstr="0":dfm=0[0], String[FormatDateTime(str,dfm)], String[12:00:00 AM], Stringstr="0":dfm=1[0], String[FormatDateTime(str,dfm)], String[Saturday, December 30, 1899], Stringstr="0":dfm=2[0], String[FormatDateTime(str,dfm)], String[12/30/1899], Stringstr="0":dfm=3[0], String[FormatDateTime(str,dfm)], String[12:00:00 AM], Stringstr="0":dfm=4[0], String[FormatDateTime(str,dfm)], String[00:00], Stringstr="-1"[-1], String[FormatDateTime(str)], String[12/29/1899], Stringstr="-1":dfm=0[-1], String[FormatDateTime(str,dfm)], String[12/29/1899], Stringstr="-1":dfm=1[-1], String[FormatDateTime(str,dfm)], String[Friday, December 29, 1899], Stringstr="-1":dfm=2[-1], String[FormatDateTime(str,dfm)], String[12/29/1899], Stringstr="-1":dfm=3[-1], String[FormatDateTime(str,dfm)], String[12:00:00 AM], Stringstr="-1":dfm=4[-1], String[FormatDateTime(str,dfm)], String[00:00], Stringstr="1"[1], String[FormatDateTime(str)], String[12/31/1899], Stringstr="1":dfm=0[1], String[FormatDateTime(str,dfm)], String[12/31/1899], Stringstr="1":dfm=1[1], String[FormatDateTime(str,dfm)], String[Sunday, December 31, 1899], Stringstr="1":dfm=2[1], String[FormatDateTime(str,dfm)], String[12/31/1899], Stringstr="1":dfm=3[1], String[FormatDateTime(str,dfm)], String[12:00:00 AM], Stringstr="1":dfm=4[1], String[FormatDateTime(str,dfm)], String[00:00], Stringstr=0[0], Integer[FormatDateTime(str)], String[12:00:00 AM], Stringstr=0:dfm=0[0], Integer[FormatDateTime(str,dfm)], String[12:00:00 AM], Stringstr=0:dfm=1[0], Integer[FormatDateTime(str,dfm)], String[Saturday, December 30, 1899], Stringstr=0:dfm=2[0], Integer[FormatDateTime(str,dfm)], String[12/30/1899], Stringstr=0:dfm=3[0], Integer[FormatDateTime(str,dfm)], String[12:00:00 AM], Stringstr=0:dfm=4[0], Integer[FormatDateTime(str,dfm)], String[00:00], Stringstr=-1[-1], Integer[FormatDateTime(str)], String[12/29/1899], Stringstr=-1:dfm=0[-1], Integer[FormatDateTime(str,dfm)], String[12/29/1899], Stringstr=-1:dfm=1[-1], Integer[FormatDateTime(str,dfm)], String[Friday, December 29, 1899], Stringstr=-1:dfm=2[-1], Integer[FormatDateTime(str,dfm)], String[12/29/1899], Stringstr=-1:dfm=3[-1], Integer[FormatDateTime(str,dfm)], String[12:00:00 AM], Stringstr=-1:dfm=4[-1], Integer[FormatDateTime(str,dfm)], String[00:00], Stringstr=1[1], Integer[FormatDateTime(str)], String[12/31/1899], Stringstr=1:dfm=0[1], Integer[FormatDateTime(str,dfm)], String[12/31/1899], Stringstr=1:dfm=1[1], Integer[FormatDateTime(str,dfm)], String[Sunday, December 31, 1899], Stringstr=1:dfm=2[1], Integer[FormatDateTime(str,dfm)], String[12/31/1899], Stringstr=1:dfm=3[1], Integer[FormatDateTime(str,dfm)], String[12:00:00 AM], Stringstr=1:dfm=4[1], Integer[FormatDateTime(str,dfm)], String[00:00], String

Sources

  •  
Previous Month  MAR  2018  Next Month
SMTWTFS
123
45678910
11121314151617
18192021222324
25262728293031

Previous Month  MAR  2012  Next Month
SMTWTFS
123
45678910
11121314151617
18192021222324
25262728293031

Sideway BICK Blog

18/03

Copyright © 2000-2020 Sideway . All rights reserved Disclaimerslast modified on 26 January 2013