DateSerial Function

Abs Function,Array Function,Asc Function,Atn Function,CBool Function,CByte Function,CCur Function,CDate Function,CDbl Function,Chr Function,CInt Function,CLng Function,Cos Function,CreateObject Function,CSng Function,CStr Function,Date Function,DateAdd Function,DateDiff Function,DatePart Function,DateSerial Function,DateValue Function,Day Function,Eval Function,Exp Function,Filter Function,Fix Function,FormatCurrency Function,FormatDateTime Function,FormatNumber Function,FormatPercent Function,GetLocale Function,GetObject Function,GetRef Function,Hex Function,Hour Function,InputBox Function,InStr Function,InStrRev Function,Int Function,IsArray Function,IsDate Function,IsEmpty Function,IsNull Function,IsNumeric Function,IsObject Function,Join Function,LBound Function,LCase Function,Left Function,Len Function,LoadPicture Function,Log Function,LTrim Function,Mid Function,Minute Function,Month Function,MonthName Function,MsgBox Function,Now Function,Oct Function,Replace Function,RGB Function,Right Function,Rnd Function,Round Function,RTrim Function,ScriptEngine Function,ScriptEngineBuildVersion Function,ScriptEngineMajorVersion Function,ScriptEngineMinorVersion Function,Second Function,Sgn Function,Sin Function,Space Function,Split Function,Sqr Function,StrComp Function,String Function,StrReverse Function,Tan Function,Time Function,Timer Function,TimeSerial Function,TimeValue Function,Trim Function,TypeName Function,UBound Function,UCase Function,VarType Function,Weekday Function,WeekdayName Function,Year Function Home home | Other Resources other resources | Advertise with us advertise | Link to us link to us | Contact us contact | Bookmark Us!
Google
 
Constants Errors Events Functions Keywords Methods Miscellaneous Objects Operators Properties Statements File System Object
Where can I find good Windows Web Hosting to host my VBScript Site?
You can find good Windows Hosting which support VBScript, ASP, ASP.Net,VisualStudio.Net and MSSQL at a very reasonable low monthly fee at EasyCGI.com and DiscountASP.Net
  Home > Functions > DateSerial Function
  • Abs Function
  • Array Function
  • Asc Function
  • Atn Function
  • CBool Function
  • CByte Function
  • CCur Function
  • CDate Function
  • CDbl Function
  • Chr Function
  • CInt Function
  • CLng Function
  • Cos Function
  • CreateObject Function
  • CSng Function
  • CStr Function
  • Date Function
  • DateAdd Function
  • DateDiff Function
  • DatePart Function
  • DateSerial Function
  • DateValue Function
  • Day Function
  • Eval Function
  • Exp Function
  • Filter Function
  • Fix Function
  • FormatCurrency Function
  • FormatDateTime Function
  • FormatNumber Function
  • FormatPercent Function
  • GetLocale Function
  • GetObject Function
  • GetRef Function
  • Hex Function
  • Hour Function
  • InputBox Function
  • InStr Function
  • InStrRev Function
  • Int Function
  • IsArray Function
  • IsDate Function
  • IsEmpty Function
  • IsNull Function
  • IsNumeric Function
  • IsObject Function
  • Join Function
  • LBound Function
  • LCase Function
  • Left Function
  • Len Function
  • LoadPicture Function
  • Log Function
  • LTrim Function
  • Mid Function
  • Minute Function
  • Month Function
  • MonthName Function
  • MsgBox Function
  • Now Function
  • Oct Function
  • Replace Function
  • RGB Function
  • Right Function
  • Rnd Function
  • Round Function
  • RTrim Function
  • ScriptEngine Function
  • ScriptEngineBuildVersion Function
  • ScriptEngineMajorVersion Function
  • ScriptEngineMinorVersion Function
  • Second Function
  • Sgn Function
  • Sin Function
  • Space Function
  • Split Function
  • Sqr Function
  • StrComp Function
  • String Function
  • StrReverse Function
  • Tan Function
  • Time Function
  • Timer Function
  • TimeSerial Function
  • TimeValue Function
  • Trim Function
  • TypeName Function
  • UBound Function
  • UCase Function
  • VarType Function
  • Weekday Function
  • WeekdayName Function
  • Year Function

    • DateSerial Function

    Returns a Variant of subtype Date for a specified year, month, and day.

    DateSerial(year, month, day)

    Arguments

    year

    Number between 100 and 9999, inclusive, or a numeric expression.

    month

    Any numeric expression.

    day

    Any numeric expression.

    Remarks

    To specify a date, such as December 31, 1991, the range of numbers for each DateSerial argument should be in the accepted range for the unit; that is, 1–31 for days and 1–12 for months. However, you can also specify relative dates for each argument using any numeric expression that represents some number of days, months, or years before or after a certain date.

    The following example uses numeric expressions instead of absolute date numbers. Here the DateSerial function returns a date that is the day before the first day (1 – 1) of two months before August (8 – 2) of 10 years before 1990 (1990 – 10); in other words, May 31, 1980. 

    Dim MyDate1, MyDate2
MyDate1 = DateSerial(1970, 1, 1)   ' Returns January 1, 1970.
MyDate2 = DateSerial(1990 - 10, 8 - 2, 1 - 1)   ' Returns May 31, 1980.

    For the year argument, values between 0 and 99, inclusive, are interpreted as the years 1900–1999. For all other year arguments, use a complete four-digit year (for example, 1800).

    When any argument exceeds the accepted range for that argument, it increments to the next larger unit as appropriate. For example, if you specify 35 days, it is evaluated as one month and some number of days, depending on where in the year it is applied. However, if any single argument is outside the range -32,768 to 32,767, or if the date specified by the three arguments, either directly or by expression, falls outside the acceptable range of dates, an error occurs.


    Constants  |   Errors  |   Events  |   Functions  |   Keywords  |   Methods  |   Miscellaneous  |   Objects  |   Operators  |   Properties  |   Statements  |   FileSystem Objects
    VBScriptOnline.com - Abs Function,Array Function,Asc Function,Atn Function,CBool Function,CByte Function,CCur Function,CDate Function,CDbl Function,Chr Function,CInt Function,CLng Function,Cos Function,CreateObject Function,CSng Function,CStr Function,Date Function,DateAdd Function,DateDiff Function,DatePart Function,DateSerial Function,DateValue Function,Day Function,Eval Function,Exp Function,Filter Function,Fix Function,FormatCurrency Function,FormatDateTime Function,FormatNumber Function,FormatPercent Function,GetLocale Function,GetObject Function,GetRef Function,Hex Function,Hour Function,InputBox Function,InStr Function,InStrRev Function,Int Function,IsArray Function,IsDate Function,IsEmpty Function,IsNull Function,IsNumeric Function,IsObject Function,Join Function,LBound Function,LCase Function,Left Function,Len Function,LoadPicture Function,Log Function,LTrim Function,Mid Function,Minute Function,Month Function,MonthName Function,MsgBox Function,Now Function,Oct Function,Replace Function,RGB Function,Right Function,Rnd Function,Round Function,RTrim Function,ScriptEngine Function,ScriptEngineBuildVersion Function,ScriptEngineMajorVersion Function,ScriptEngineMinorVersion Function,Second Function,Sgn Function,Sin Function,Space Function,Split Function,Sqr Function,StrComp Function,String Function,StrReverse Function,Tan Function,Time Function,Timer Function,TimeSerial Function,TimeValue Function,Trim Function,TypeName Function,UBound Function,UCase Function,VarType Function,Weekday Function,WeekdayName Function,Year Function