DateAdd 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 > DateAdd 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

    • DateAdd Function

    Returns a date to which a specified time interval has been added.

    DateAdd(interval, number, date)

    Arguments

    interval

    Required. String expression that is the interval you want to add. See Settings section for values.

    number

    Required. Numeric expression that is the number of interval you want to add. The numeric expression can either be positive, for dates in the future, or negative, for dates in the past.

    date

    Required. Variant or literal representing the date to which interval is added.

    Settings

    The interval argument can have the following values:

    SettingDescription
    yyyyYear
    qQuarter
    mMonth
    yDay of year
    dDay
    wWeekday
    wwWeek of year
    hHour
    nMinute
    sSecond

    Remarks

    You can use the DateAdd function to add or subtract a specified time interval from a date. For example, you can use DateAdd to calculate a date 30 days from today or a time 45 minutes from now. To add days to date, you can use Day of Year ("y"), Day ("d"), or Weekday ("w").

    The DateAdd function won't return an invalid date. The following example adds one month to January 31: 

    NewDate = DateAdd("m", 1, "31-Jan-95")

    In this case, DateAdd returns 28-Feb-95, not 31-Feb-95. If date is 31-Jan-96, it returns 29-Feb-96 because 1996 is a leap year.

    If the calculated date would precede the year 100, an error occurs.

    If number isn't a Long value, it is rounded to the nearest whole number before being evaluated.


    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