14 th Dec 2019 18:24:07
Hai Friend , Sign In
Chennai City
IP 2 Location
G. K.
Tamil Nadu Government Holiday List 2018 in English and Tamil   *   Trichy: Wanted - PHP, MySql Programmers. Contact trichy people only 84894 28 444.   *   Indian Railways New Train Number List [Search / Enquiry / Locator / Finder]   *   பன்றிக் காய்ச்சல் பற்றி அறிந்து கொள்ளுங்கள் (Swine Flu H1N1)
See Also
Datediff Function DateDiff Function
Datepart Function DatePart Function
Date Time Functions Date Time Functions
Visual Basic Functions Visual Basic Functions
Visual Basic Home Visual Basic Home
Description  Syntax  Return Datatype  Example  Migration

DateAdd Function - Visual Basic 6.0 (VB 6.0)

Returns a Variant (Date) containing a date to which a specified time interval has been added.
DateAdd(interval, number, date)
Parameter Description
interval Required. The interval you want to add.
number Required. The number of interval you want to add. 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.

DateAdd Function intervals:
Interval Strings Description
s Second
n Minute
h Hour
d Day
m Month
yyyy Year
y Day of year
q Quarter
ww Week of year
w Weekday
Note: To add days to date, you can use Day of Year ("y"), Day ("d"), or Weekday ("w").
Return Data type:
DateAdd Returns Results in System's Short Date Format.
Current System's Short Date Format: dd/MM/yyyy.
Current System Date and Time is:

Statement Result Remark
DateAdd("s", 10, Now)  
DateAdd("n", 10, Now)  
DateAdd("h", 2.5, Now) number should be Long.
DateAdd("d", 7, Date)  
DateAdd("m", 2, Date)  
DateAdd("yyyy", 1, Date)  
DateAdd("y", 5, Date)  
DateAdd("q", 1, Date)  
DateAdd("ww", 2, Date)  
DateAdd("w", 1, Date)  
Go to top

Migration from Visual Basic 6.0 (VB 6.0) to
  DateAdd Function in VB Script (VBS)
  DateAdd Function in JScript (JS)
  DateAdd Function in ASP (Active Server Page)
  DateAdd Function in PHP Script
  DateAdd Function in MS-Access
  DateAdd Function in MS SQL Server
  DateAdd Function in Oracle
  DateAdd Function in C Language
  DateAdd Function in C++ Language
  DateAdd Function in Foxpro
  DateAdd Function in Fortran
  DateAdd Function in MS Excel Sheet
Go to top

© 2005 - 2007 Chennaiiq.com. All Rights Reserved.

Our Sites: ChennaiIQ.com || Tamil Calendar || Tamil Panchangam || KP Astrology
Our Blogs: Tamil Calendar